/*
 Navicat Premium Data Transfer

 Source Server         : (本地)3306
 Source Server Type    : MySQL
 Source Server Version : 80036 (8.0.36)
 Source Host           : localhost:3306
 Source Schema         : system

 Target Server Type    : MySQL
 Target Server Version : 80036 (8.0.36)
 File Encoding         : 65001

 Date: 30/08/2025 19:29:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for business_role
-- ----------------------------
DROP TABLE IF EXISTS `business_role`;
CREATE TABLE `business_role` (
                                 `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键id',
                                 `create_by` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
                                 `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                 `update_by` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新人',
                                 `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                 `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
                                 `del_flag` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '删除标识（0：未删除 1：已删除）',
                                 `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
                                 PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of business_role
-- ----------------------------
BEGIN;
INSERT INTO `business_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `name`) VALUES ('0a4dc98c42924dacafda187a447e86bd', NULL, '2025-08-19 10:52:55', NULL, '2025-08-20 21:50:16', NULL, '1', '11');
INSERT INTO `business_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `name`) VALUES ('1', NULL, '2025-08-14 09:16:54', NULL, '2025-08-14 09:16:54', NULL, '0', '系统管理员');
INSERT INTO `business_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `name`) VALUES ('2', NULL, '2025-08-14 09:17:05', NULL, '2025-08-14 09:17:05', NULL, '0', '普通用户');
COMMIT;

-- ----------------------------
-- Table structure for business_role_resource
-- ----------------------------
DROP TABLE IF EXISTS `business_role_resource`;
CREATE TABLE `business_role_resource` (
                                          `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键id',
                                          `create_by` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
                                          `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                          `update_by` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新人',
                                          `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                          `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
                                          `del_flag` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '删除标识（0：未删除 1：已删除）',
                                          `role_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                          `resource_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                          PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of business_role_resource
-- ----------------------------
BEGIN;
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('032cb0e874ed484bbe8227cad7e42d7c', NULL, '2025-08-20 21:49:57', NULL, '2025-08-23 19:11:57', NULL, '1', '2', 'b0216da124a449138c48aed53cc4ed6a');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('03efe2ac66d1429697871639cbffb631', NULL, '2025-08-20 21:47:11', NULL, '2025-08-20 21:47:11', NULL, '0', '0a4dc98c42924dacafda187a447e86bd', '011b0eeb2b794be4bbc1b0c4fe2a2719');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('14336e0e3474459ebb9c2f20e193a94e', NULL, '2025-08-23 19:12:03', NULL, '2025-08-23 19:12:03', NULL, '0', '1', '1b01f57f5f1d4509a9a6022810722352');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('16c68e6669e44ce18d6306d1423c5a4d', NULL, '2025-08-23 19:11:57', NULL, '2025-08-23 19:11:57', NULL, '0', '2', 'ad35f5c9ae914961bb43080b0582cb50');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('1cdf73aa04554609b0cc32e0cd2fe2c7', NULL, '2025-08-20 22:13:20', NULL, '2025-08-23 19:11:57', NULL, '1', '2', 'a26b887d85da4f83b1ebcf363320caef');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('36302847912a427a98c68a5854d3bf18', NULL, '2025-08-19 16:54:45', NULL, '2025-08-19 16:54:45', NULL, '0', '0a4dc98c42924dacafda187a447e86bd', '369ef6aa57da4307b0b685edf50fd564');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('376e980daa084274b4ee30e146428f3b', NULL, '2025-08-23 19:11:57', NULL, '2025-08-23 19:11:57', NULL, '0', '2', '3a01057a9c6940269f25749a80d055e8');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('3996179f3cc14044b17f6b5c731b5dca', NULL, '2025-08-20 22:28:32', NULL, '2025-08-23 19:11:57', NULL, '1', '2', '011b0eeb2b794be4bbc1b0c4fe2a2719');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('426308e99bde42aab0cb966ae6a5cdb7', NULL, '2025-08-20 21:49:57', NULL, '2025-08-23 19:11:57', NULL, '1', '2', '369ef6aa57da4307b0b685edf50fd564');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('5b4b9c8e0a42406eac208a5491af8de3', NULL, '2025-08-23 19:12:03', NULL, '2025-08-23 19:12:03', NULL, '0', '1', 'ad35f5c9ae914961bb43080b0582cb50');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('63fab241b1dc45f8830e5cc581c831a4', NULL, '2025-08-23 19:11:57', NULL, '2025-08-23 19:11:57', NULL, '0', '2', '1b01f57f5f1d4509a9a6022810722352');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('6c2147f0c4b347728938ce0372324968', NULL, '2025-08-20 22:28:17', NULL, '2025-08-20 22:28:25', NULL, '1', '1', '011b0eeb2b794be4bbc1b0c4fe2a2719');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('93c5c643856140dbb5f4872416cbe09d', NULL, '2025-08-19 16:54:45', NULL, '2025-08-19 16:54:45', NULL, '0', '0a4dc98c42924dacafda187a447e86bd', 'b0216da124a449138c48aed53cc4ed6a');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('a110862133f340bbbeedfb83d57c607e', NULL, '2025-08-23 19:12:03', NULL, '2025-08-23 19:12:03', NULL, '0', '1', '3a01057a9c6940269f25749a80d055e8');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('a6064a4ea91b40ec9dafde14dcade254', NULL, '2025-08-20 21:50:13', NULL, '2025-08-23 19:12:03', NULL, '1', '1', '369ef6aa57da4307b0b685edf50fd564');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('a932cb2acdd94677b2a2a8d56a3020b6', NULL, '2025-08-19 20:42:41', NULL, '2025-08-20 20:34:03', NULL, '1', '0a4dc98c42924dacafda187a447e86bd', '0d7325a0779d428db5fbfd6bc6a95e1c');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('b10e9062243b416a92137b86de0e3396', NULL, '2025-08-19 20:42:41', NULL, '2025-08-20 20:34:03', NULL, '1', '0a4dc98c42924dacafda187a447e86bd', 'b6407f4a228144599929f0ffae7dc3c4');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('b36dd2068dd74e7eafddb266231b1125', NULL, '2025-08-20 21:50:13', NULL, '2025-08-20 21:50:26', NULL, '1', '1', '011b0eeb2b794be4bbc1b0c4fe2a2719');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('cecbda262ebc48638f0ce54b9fa73195', NULL, '2025-08-19 16:56:06', NULL, '2025-08-19 16:56:38', NULL, '1', '0a4dc98c42924dacafda187a447e86bd', '0d7325a0779d428db5fbfd6bc6a95e1c');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('d740f7b7deab463587f3d92ad53ae704', NULL, '2025-08-20 21:50:13', NULL, '2025-08-23 19:12:03', NULL, '1', '1', 'b0216da124a449138c48aed53cc4ed6a');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('e05827cdddf34e0c87834016eb2747c0', NULL, '2025-08-19 15:14:20', NULL, '2025-08-19 16:55:29', NULL, '1', '0a4dc98c42924dacafda187a447e86bd', 'b6407f4a228144599929f0ffae7dc3c4');
INSERT INTO `business_role_resource` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `resource_id`) VALUES ('fbcf33b1c93e405d90a613430aaa25c9', NULL, '2025-08-19 15:14:20', NULL, '2025-08-19 16:55:29', NULL, '1', '0a4dc98c42924dacafda187a447e86bd', '0d7325a0779d428db5fbfd6bc6a95e1c');
COMMIT;

-- ----------------------------
-- Table structure for business_user
-- ----------------------------
DROP TABLE IF EXISTS `business_user`;
CREATE TABLE `business_user` (
                                 `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键id',
                                 `create_by` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
                                 `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
                                 `update_by` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新人',
                                 `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
                                 `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
                                 `del_flag` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '删除标识（0：未删除 1：已删除）',
                                 `account` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                 `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                 `mobile` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                 `sex` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '0:男1:女',
                                 `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '姓名',
                                 `age` int DEFAULT NULL,
                                 PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of business_user
-- ----------------------------
BEGIN;
INSERT INTO `business_user` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `account`, `password`, `mobile`, `sex`, `name`, `age`) VALUES ('059f011f5aa8481f84c94d84780891d3', NULL, '2025-08-18 13:39:37', NULL, '2025-08-18 11:54:29', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `business_user` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `account`, `password`, `mobile`, `sex`, `name`, `age`) VALUES ('1', NULL, '2025-08-28 20:04:15', NULL, NULL, NULL, '1', 'admin1', '666666', NULL, '0', '111', 1);
INSERT INTO `business_user` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `account`, `password`, `mobile`, `sex`, `name`, `age`) VALUES ('17c2183329f540afb46396eb738add16', NULL, '2025-08-18 13:43:13', NULL, '2025-08-18 11:37:14', NULL, '1', 'guotao', '666666', NULL, '0', '郭涛', 18);
INSERT INTO `business_user` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `account`, `password`, `mobile`, `sex`, `name`, `age`) VALUES ('1f54aa6534c34f13a0b354a92c4eb60b', NULL, '2025-08-18 13:43:01', NULL, '2025-08-18 11:39:28', NULL, '1', 'admin3', '666666', NULL, '1', NULL, NULL);
INSERT INTO `business_user` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `account`, `password`, `mobile`, `sex`, `name`, `age`) VALUES ('4ba777336dbc415db5dc48f9452caf80', NULL, '2025-08-18 13:42:56', NULL, '2025-08-18 13:09:03', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `business_user` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `account`, `password`, `mobile`, `sex`, `name`, `age`) VALUES ('5e0710aa92a448c4ba51cf4ae532f81b', NULL, '2025-08-18 13:42:58', NULL, '2025-08-18 11:54:22', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `business_user` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `account`, `password`, `mobile`, `sex`, `name`, `age`) VALUES ('616031df9b40409ca1746883043e7b11', NULL, '2025-08-18 13:43:17', NULL, '2025-08-18 11:37:12', NULL, '1', 'guotao', '666666', NULL, '0', '郭涛', 18);
INSERT INTO `business_user` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `account`, `password`, `mobile`, `sex`, `name`, `age`) VALUES ('684ce4b2b560433a858b435199e1338f', NULL, '2025-08-18 13:43:07', NULL, '2025-08-18 11:37:03', NULL, '1', 'guotao', '666666', NULL, '0', '郭涛', 18);
INSERT INTO `business_user` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `account`, `password`, `mobile`, `sex`, `name`, `age`) VALUES ('795908ab2673408b81aeed1ce1d0539c', NULL, '2025-08-18 13:43:03', NULL, '2025-08-13 17:24:54', NULL, '1', 'admin2', '666666', '1', '0', NULL, 12);
INSERT INTO `business_user` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `account`, `password`, `mobile`, `sex`, `name`, `age`) VALUES ('7c0650be4a6d46028f3ab79a8aa6cb53', NULL, '2025-08-18 13:43:05', NULL, '2025-08-18 11:40:56', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `business_user` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `account`, `password`, `mobile`, `sex`, `name`, `age`) VALUES ('bbf1be7d1bf8490a9c64110109f2711f', NULL, '2025-08-18 13:43:09', NULL, '2025-08-18 13:10:43', NULL, '1', 'guotao01', '666666', NULL, '1', '11', 2);
INSERT INTO `business_user` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `account`, `password`, `mobile`, `sex`, `name`, `age`) VALUES ('d366d6e48ca24dc2aca2d6cc21fb8442', NULL, '2025-08-18 13:43:11', NULL, '2025-08-18 11:39:21', NULL, '1', 'admin3', '666666', NULL, '1', NULL, NULL);
INSERT INTO `business_user` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `account`, `password`, `mobile`, `sex`, `name`, `age`) VALUES ('e17134a0db6d4a8ba47c21905777e495', NULL, '2025-08-28 20:04:13', NULL, '2025-08-23 19:11:42', NULL, '1', 'guotao', '666666', NULL, '0', 'guotao', 123);
INSERT INTO `business_user` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `account`, `password`, `mobile`, `sex`, `name`, `age`) VALUES ('e5156da73a504ff88913b5f03c83a101', NULL, '2025-08-18 14:40:21', NULL, '2025-08-18 09:22:15', NULL, '1', 'admin3', '666666', '13863127732', '1', NULL, 132);
INSERT INTO `business_user` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `account`, `password`, `mobile`, `sex`, `name`, `age`) VALUES ('e60aa143aa9e4435b157069b4c8bf20f', NULL, '2025-08-19 20:44:04', NULL, '2025-08-18 14:40:40', NULL, '0', 'admin', '666666', NULL, '0', '系统管理员', 1);
COMMIT;

-- ----------------------------
-- Table structure for business_user_role
-- ----------------------------
DROP TABLE IF EXISTS `business_user_role`;
CREATE TABLE `business_user_role` (
                                      `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键id',
                                      `create_by` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
                                      `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                      `update_by` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新人',
                                      `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                      `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
                                      `del_flag` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '删除标识（0：未删除 1：已删除）',
                                      `role_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                      `user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                      PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of business_user_role
-- ----------------------------
BEGIN;
INSERT INTO `business_user_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `user_id`) VALUES ('0b674d6691fe48f2b69cb2d8426954cc', NULL, '2025-08-18 13:43:45', NULL, '2025-08-18 13:43:48', NULL, '1', '1', '1');
INSERT INTO `business_user_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `user_id`) VALUES ('3fbf3346e4074f669136c98b74b89fde', NULL, '2025-08-18 13:43:52', NULL, '2025-08-18 13:43:56', NULL, '1', '1', '1');
INSERT INTO `business_user_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `user_id`) VALUES ('53dd9934155e45b2915acf1c56b643de', NULL, '2025-08-18 09:50:13', NULL, '2025-08-18 13:43:38', NULL, '1', '1', '1');
INSERT INTO `business_user_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `user_id`) VALUES ('6d0883ac73de4640ae131a81188ee1e6', NULL, '2025-08-18 09:53:17', NULL, '2025-08-18 09:53:20', NULL, '1', '2', '795908ab2673408b81aeed1ce1d0539c');
INSERT INTO `business_user_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `user_id`) VALUES ('885ae3fdea344c61ac12fe7b6f7f568f', NULL, '2025-08-18 13:43:38', NULL, '2025-08-18 13:43:52', NULL, '1', '2', '1');
INSERT INTO `business_user_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `user_id`) VALUES ('8951e119b8f3471ab7c44d9130b45ff7', NULL, '2025-08-18 09:14:22', NULL, '2025-08-18 09:40:15', NULL, '1', '2', '1');
INSERT INTO `business_user_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `user_id`) VALUES ('8b03cfa177284e6db40f792130a9eb0b', NULL, '2025-08-18 14:46:01', NULL, '2025-08-18 14:46:01', NULL, '0', '2', 'e60aa143aa9e4435b157069b4c8bf20f');
INSERT INTO `business_user_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `user_id`) VALUES ('8d2e2c407f6e4255953b408d16c1ebdc', NULL, '2025-08-18 14:46:01', NULL, '2025-08-18 14:46:01', NULL, '0', '1', 'e60aa143aa9e4435b157069b4c8bf20f');
INSERT INTO `business_user_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `user_id`) VALUES ('95a52486b0d34195812958c0e4c650a5', NULL, '2025-08-18 09:53:37', NULL, '2025-08-18 13:43:52', NULL, '1', '2', '795908ab2673408b81aeed1ce1d0539c');
INSERT INTO `business_user_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `user_id`) VALUES ('bb8ff8afb9be4733b29cbd401c6268ba', NULL, '2025-08-18 13:44:00', NULL, '2025-08-18 13:44:00', NULL, '0', '2', '1');
INSERT INTO `business_user_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `user_id`) VALUES ('d0279a30299741e2accfe50db7903a87', NULL, '2025-08-19 20:43:29', NULL, '2025-08-19 20:43:29', NULL, '0', '0a4dc98c42924dacafda187a447e86bd', 'e60aa143aa9e4435b157069b4c8bf20f');
INSERT INTO `business_user_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `user_id`) VALUES ('d54a04fcba6e481a9be08b58ad37617e', NULL, '2025-08-18 09:04:29', NULL, '2025-08-18 13:43:38', NULL, '1', '1', '1');
INSERT INTO `business_user_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `user_id`) VALUES ('f1554d5edef94799940085a7b4aba014', NULL, '2025-08-19 21:34:26', NULL, '2025-08-19 21:34:26', NULL, '0', '1', '1');
INSERT INTO `business_user_role` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `role_id`, `user_id`) VALUES ('fb9435af03c647d9afd9f609e426c1a3', NULL, '2025-08-18 09:53:13', NULL, '2025-08-18 13:43:38', NULL, '1', '1', '795908ab2673408b81aeed1ce1d0539c');
COMMIT;

-- ----------------------------
-- Table structure for data_dict
-- ----------------------------
DROP TABLE IF EXISTS `data_dict`;
CREATE TABLE `data_dict` (
                             `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键id',
                             `dict_label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                             `dict_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                             `create_by` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
                             `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                             `update_by` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新人',
                             `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                             `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
                             `del_flag` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '删除标识（0：未删除 1：已删除）',
                             PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of data_dict
-- ----------------------------
BEGIN;
INSERT INTO `data_dict` (`id`, `dict_label`, `dict_name`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`) VALUES ('2c886e272d9b4638a9b02646c418401a', '状态', 'dict_status', NULL, '2025-08-20 10:54:37', NULL, '2025-08-20 10:54:37', NULL, '0');
INSERT INTO `data_dict` (`id`, `dict_label`, `dict_name`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`) VALUES ('862116f96e20447192077ce8916182c3', 'qwe', 'e', NULL, '2025-08-20 10:34:15', NULL, '2025-08-20 10:38:30', NULL, '1');
INSERT INTO `data_dict` (`id`, `dict_label`, `dict_name`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`) VALUES ('8ddc3cd76afb4ae19ef7c3cd74abb252', '性别', 'dict_sex', NULL, '2025-08-19 16:36:06', NULL, '2025-08-20 10:31:47', NULL, '0');
INSERT INTO `data_dict` (`id`, `dict_label`, `dict_name`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`) VALUES ('93fa6b770da8463481599420dbdf6947', '图书状态', 'book_status', NULL, '2025-08-23 13:20:37', NULL, '2025-08-23 13:20:37', NULL, '0');
INSERT INTO `data_dict` (`id`, `dict_label`, `dict_name`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`) VALUES ('c0078f4054df481d9a5a6eb3b69fb2a5', '状态', 'status', NULL, '2025-08-20 00:13:41', NULL, '2025-08-20 10:54:27', NULL, '1');
COMMIT;

-- ----------------------------
-- Table structure for data_dict_item
-- ----------------------------
DROP TABLE IF EXISTS `data_dict_item`;
CREATE TABLE `data_dict_item` (
                                  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键id',
                                  `dict_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                  `create_by` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
                                  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                  `update_by` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新人',
                                  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                  `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
                                  `del_flag` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '删除标识（0：未删除 1：已删除）',
                                  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of data_dict_item
-- ----------------------------
BEGIN;
INSERT INTO `data_dict_item` (`id`, `dict_name`, `label`, `value`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`) VALUES ('131f6826778b4538a8eb5956d22eb0eb', 'status', '正常', '1', NULL, '2025-08-20 00:14:14', NULL, '2025-08-20 00:14:14', NULL, '0');
INSERT INTO `data_dict_item` (`id`, `dict_name`, `label`, `value`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`) VALUES ('1afbd1bbdf4940b69d38b4422df5f297', 'status', '错误', '2', NULL, '2025-08-20 00:14:22', NULL, '2025-08-20 00:14:22', NULL, '0');
INSERT INTO `data_dict_item` (`id`, `dict_name`, `label`, `value`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`) VALUES ('4cac4e01bf234061a1c7eaece05344ad', 'book_status', '未借阅', '0', NULL, '2025-08-23 13:21:29', NULL, '2025-08-23 13:22:28', NULL, '0');
INSERT INTO `data_dict_item` (`id`, `dict_name`, `label`, `value`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`) VALUES ('95d65f81c5244bdf990606829daf90a1', 'dict_status', '停用', '1', NULL, '2025-08-20 10:55:14', NULL, '2025-08-20 10:55:14', NULL, '0');
INSERT INTO `data_dict_item` (`id`, `dict_name`, `label`, `value`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`) VALUES ('aad34022cc26400dbcb957c59032de12', 'dict_sex', '233', '3', NULL, '2025-08-20 00:13:13', NULL, '2025-08-20 10:52:50', NULL, '1');
INSERT INTO `data_dict_item` (`id`, `dict_name`, `label`, `value`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`) VALUES ('c5622a6d540444308fa5056686cabecf', 'dict_status', '正常', '0', NULL, '2025-08-20 10:55:03', NULL, '2025-08-20 10:55:03', NULL, '0');
INSERT INTO `data_dict_item` (`id`, `dict_name`, `label`, `value`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`) VALUES ('dcf4ac5bd8254a58a564dc7aa68eb58d', 'dict_sex', '213', 'ff23', NULL, '2025-08-20 00:13:19', NULL, '2025-08-20 10:53:05', NULL, '0');
INSERT INTO `data_dict_item` (`id`, `dict_name`, `label`, `value`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`) VALUES ('e7707c9c509b4992adaf438a86f4a094', 'book_status', '已借阅', '1', NULL, '2025-08-23 13:21:37', NULL, '2025-08-23 13:22:33', NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for system_application
-- ----------------------------
DROP TABLE IF EXISTS `system_application`;
CREATE TABLE `system_application` (
                                      `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
                                      `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '应用名称',
                                      `user_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '所有人名称',
                                      `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '删除标识（0 未删除 1 已删除）',
                                      `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                      `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                      `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                      `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                      `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                      `background_url` varchar(255) DEFAULT NULL COMMENT '背景图片',
                                      `enter_app_before_login` varchar(1) DEFAULT '1',
                                      PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of system_application
-- ----------------------------
BEGIN;
INSERT INTO `system_application` (`id`, `name`, `user_name`, `del_flag`, `create_time`, `update_time`, `create_by`, `update_by`, `remarks`, `background_url`, `enter_app_before_login`) VALUES ('000000000000000000000000000000', '通用菜单（初始化用）1', '系统管理员', '0', '2025-07-24 09:57:05', '2025-08-28 22:08:23', NULL, NULL, NULL, 'c9209e166aec411bbe9c8abc65214753.jpg', '1');
COMMIT;

-- ----------------------------
-- Table structure for system_application_service
-- ----------------------------
DROP TABLE IF EXISTS `system_application_service`;
CREATE TABLE `system_application_service` (
                                              `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
                                              `parent_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '父级id',
                                              `app_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '应用id',
                                              `data` json DEFAULT NULL,
                                              `type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '类型 1:文件夹 2:api接口 3:model类型',
                                              `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '接口路径',
                                              `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                              `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                              `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '删除标识（0 未删除 1已删除）',
                                              `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                              `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                              `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                              `sort` int DEFAULT '0' COMMENT '排序',
                                              `extra` json DEFAULT NULL,
                                              PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of system_application_service
-- ----------------------------
BEGIN;
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('090a47673a014534b64f52a5dee605a1', 'b50ff8b82ccc4163953e81bcaf78fb1c', '000000000000000000000000000000', NULL, '1', '接口', '2025-08-13 11:33:35', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 0, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('0b31d52bc7424150937528f0bc7f78aa', '5d3fe37226644eac8b1abb4aa1ed28c2', '000000000000000000000000000000', '{\"action\": \"update\", \"modelName\": \"TestModel\"}', '2', '/test/update', '2025-08-29 23:29:52', '2025-08-29 23:30:06', '0', NULL, NULL, NULL, 1, NULL);
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('13197a5cef7c49ef928f5065b5ce8dce', 'a3ec5fc6b5904cbd90e49048237be14c', '000000000000000000000000000000', NULL, '1', '数据字典', '2025-08-19 16:11:35', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 2, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('14a7df02054e481190e042ef5a50a9ba', 'a906a8d33e2e4f5294da872c7a9750a3', '000000000000000000000000000000', '{\"action\": \"queryDict\", \"modelName\": \"DatadictModel\"}', '2', '/data-dict/query', '2025-08-19 16:15:35', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 4, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('1f4a7a21d3fc43f591f1af78c0849273', 'be9359e2e0cc44978cf409ba32751329', '000000000000000000000000000000', '{\"field\": [{\"id\": 1755139541187, \"name\": \"id\", \"sort\": 0, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"主键id\", \"required\": true, \"aliasName\": \"id\", \"maxLength\": 36, \"primaryKey\": true}, {\"id\": 1755139541188, \"name\": \"create_by\", \"sort\": 1, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"创建人\", \"aliasName\": \"createBy\", \"maxLength\": 36, \"primaryKey\": false}, {\"id\": 1755139541189, \"name\": \"create_time\", \"sort\": 2, \"type\": \"datetime\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"创建时间\", \"aliasName\": \"createTime\", \"maxLength\": 0, \"primaryKey\": false, \"defaultValue\": \"CURRENT_TIMESTAMP\"}, {\"id\": 1755139541190, \"name\": \"update_by\", \"sort\": 3, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"更新人\", \"aliasName\": \"updateBy\", \"maxLength\": 36, \"primaryKey\": false}, {\"id\": 1755139541191, \"name\": \"update_time\", \"sort\": 4, \"type\": \"datetime\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"更新时间\", \"aliasName\": \"updateTime\", \"maxLength\": 0, \"primaryKey\": false, \"defaultValue\": \"CURRENT_TIMESTAMP\", \"updateByCurrentTime\": true}, {\"id\": 1755139541192, \"name\": \"remarks\", \"sort\": 5, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"备注\", \"aliasName\": \"remarks\", \"maxLength\": 255, \"primaryKey\": false}, {\"id\": 1755139541193, \"name\": \"del_flag\", \"sort\": 6, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"删除标识（0：未删除 1：已删除）\", \"aliasName\": \"delFlag\", \"maxLength\": 1, \"primaryKey\": false, \"defaultValue\": \"0\"}, {\"id\": 1755139552413, \"name\": \"role_id\", \"sort\": 7, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"required\": false, \"aliasName\": \"roleId\", \"maxLength\": 32, \"primaryKey\": false, \"defaultValue\": \"\"}, {\"id\": 1755139563470, \"name\": \"user_id\", \"sort\": 8, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"required\": false, \"aliasName\": \"userId\", \"maxLength\": 32, \"primaryKey\": false, \"defaultValue\": \"\"}], \"table\": {\"name\": \"business_user_role\", \"engine\": \"InnoDB\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"aliasName\": \"\", \"rowFormat\": \"DYNAMIC\"}, \"action\": [{\"id\": 1755139579337, \"name\": \"addGroovy\", \"type\": \"CustomScript\", \"after\": \"\", \"label\": \"\", \"shell\": \"log.info(\\\"--------------------params{}---------------\\\",params);\\ndef roleList = params.roleList;\\ndef userId = params.userId;\\ndef userRoleParam = JSONUtil.createObj();\\nuserRoleParam.userId = userId;\\ndef hasRoleList = BusinessUserRoleModel.searchByUserId(userRoleParam);\\ndef hasRoleIdList = new LinkedList<>();\\nif(hasRoleList){\\n    hasRoleList.each{\\n        hasRoleIdList.add(it.roleId);\\n    }\\n}\\nif(roleList){\\n    roleList.split(\\\",\\\").each{\\n        if(hasRoleIdList.remove(it)){\\n            return true;\\n        }\\n        def roleUserParam = JSONUtil.createObj();\\n        roleUserParam.roleId = it;\\n        roleUserParam.userId = userId;\\n        BusinessUserRoleModel.add(roleUserParam);\\n    }\\n}\\nif(hasRoleIdList){\\n    hasRoleIdList.each{\\n        def deleteParam = JSONUtil.createObj();\\n        deleteParam.roleId = it;\\n        BusinessUserRoleModel.deleteByRoleId(deleteParam);\\n    }\\n}\\ndef result = JSONUtil.createObj();\\nresult.currentUserId = currentUserId;\\nresult.userId = params.userId;\\nreturn result;\", \"before\": \"log.info(\\\"-----params->{}\\\",params);\\nlog.info(\\\"-----currentUserId->{}\\\",currentUserId);\", \"detail\": {\"rawScript\": \"insert into <br/>&emsp;&emsp;business_user_role ( id, update_by, remarks, role_id, user_id, create_by ) <br/>values <br/>&emsp;&emsp;( \'{{id}}\' , \'{{updateBy}}\' , \'{{remarks}}\' , \'{{roleId}}\' , \'{{userId}}\' , \'{{createBy}}\' )\", \"actionType\": \"insert\", \"saveScript\": \"insert into business_user_role ( id, update_by, remarks, role_id, user_id, create_by ) values ( \'{{id}}\' , \'{{updateBy}}\' , \'{{remarks}}\' , \'{{roleId}}\' , \'{{userId}}\' , \'{{createBy}}\' )\", \"insertFieldList\": [{\"label\": \"id(主键id)\", \"value\": \"id\", \"aliasName\": \"id\", \"isParamName\": true}, {\"label\": \"create_by(创建人)\", \"value\": \"create_by\", \"aliasName\": \"createBy\", \"isParamName\": true}, {\"label\": \"create_time(创建时间)\", \"value\": \"create_time\", \"aliasName\": \"createTime\", \"isParamName\": true}, {\"label\": \"update_by(更新人)\", \"value\": \"update_by\", \"aliasName\": \"updateBy\", \"isParamName\": true}, {\"label\": \"update_time(更新时间)\", \"value\": \"update_time\", \"aliasName\": \"updateTime\", \"isParamName\": true}, {\"label\": \"remarks(备注)\", \"value\": \"remarks\", \"aliasName\": \"remarks\", \"isParamName\": true}, {\"label\": \"del_flag(删除标识（0：未删除 1：已删除）)\", \"value\": \"del_flag\", \"aliasName\": \"delFlag\", \"isParamName\": true}, {\"label\": \"role_id\", \"value\": \"role_id\", \"aliasName\": \"roleId\", \"isParamName\": true}, {\"label\": \"user_id\", \"value\": \"user_id\", \"aliasName\": \"userId\", \"isParamName\": true}], \"whereSelectList\": [], \"allInsertCheckBox\": false, \"insertCheckBoxList\": [\"id\", \"update_by\", \"remarks\", \"role_id\", \"user_id\", \"create_by\"]}}, {\"id\": 1755141977016, \"name\": \"add\", \"type\": \"SimpleInsert\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"insert into <br/>&emsp;&emsp;business_user_role ( id, role_id, user_id ) <br/>values <br/>&emsp;&emsp;( \'{{id}}\' , \'{{roleId}}\' , \'{{userId}}\' )\", \"actionType\": \"insert\", \"saveScript\": \"insert into business_user_role ( id, role_id, user_id ) values ( \'{{id}}\' , \'{{roleId}}\' , \'{{userId}}\' )\", \"insertFieldList\": [{\"label\": \"id(主键id)\", \"value\": \"id\", \"aliasName\": \"id\", \"isParamName\": true}, {\"label\": \"create_by(创建人)\", \"value\": \"create_by\", \"aliasName\": \"createBy\", \"isParamName\": true}, {\"label\": \"create_time(创建时间)\", \"value\": \"create_time\", \"aliasName\": \"createTime\", \"isParamName\": true}, {\"label\": \"update_by(更新人)\", \"value\": \"update_by\", \"aliasName\": \"updateBy\", \"isParamName\": true}, {\"label\": \"update_time(更新时间)\", \"value\": \"update_time\", \"aliasName\": \"updateTime\", \"isParamName\": true}, {\"label\": \"remarks(备注)\", \"value\": \"remarks\", \"aliasName\": \"remarks\", \"isParamName\": true}, {\"label\": \"del_flag(删除标识（0：未删除 1：已删除）)\", \"value\": \"del_flag\", \"aliasName\": \"delFlag\", \"isParamName\": true}, {\"label\": \"role_id\", \"value\": \"role_id\", \"aliasName\": \"roleId\", \"isParamName\": true}, {\"label\": \"user_id\", \"value\": \"user_id\", \"aliasName\": \"userId\", \"isParamName\": true}], \"whereSelectList\": [], \"allInsertCheckBox\": false, \"insertCheckBoxList\": [\"id\", \"role_id\", \"user_id\"]}}, {\"id\": 1755147741435, \"name\": \"list\", \"type\": \"SimpleQuery\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"params.userId = currentUserId;\", \"detail\": {\"isPage\": false, \"rawScript\": \"select <br/>&emsp;&emsp;id as id,<br/>&emsp;&emsp;create_by as createBy,<br/>&emsp;&emsp;date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,<br/>&emsp;&emsp;update_by as updateBy,<br/>&emsp;&emsp;date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,<br/>&emsp;&emsp;remarks as remarks,<br/>&emsp;&emsp;del_flag as delFlag,<br/>&emsp;&emsp;role_id as roleId,<br/>&emsp;&emsp;user_id as userId<br/> from <br/>&emsp;&emsp;business_user_role\\n       <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>\\n       &emsp;&emsp;[[AND role_id = \'{{roleId}}\']] <br/> &emsp;&emsp;[[AND user_id = \'{{userId}}\']] <br/><br/><br/>\", \"actionType\": \"select\", \"saveScript\": \"select id as id,create_by as createBy,date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,update_by as updateBy,date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,remarks as remarks,del_flag as delFlag,role_id as roleId,user_id as userId from business_user_role\\n        where del_flag = 0 \\n       [[AND role_id = \'{{roleId}}\']]  [[AND user_id = \'{{userId}}\']] \", \"fieldSelected\": [{\"table\": \"business_user_role\", \"fields\": [\"id\", \"create_by\", \"create_time\", \"update_by\", \"update_time\", \"remarks\", \"del_flag\", \"role_id\", \"user_id\"], \"isExpand\": false, \"isSelectAllField\": true, \"fieldAliasNameMapArray\": [{\"name\": \"id\", \"aliasName\": \"id\"}, {\"name\": \"create_by\", \"aliasName\": \"createBy\"}, {\"name\": \"create_time\", \"aliasName\": \"createTime\"}, {\"name\": \"update_by\", \"aliasName\": \"updateBy\"}, {\"name\": \"update_time\", \"aliasName\": \"updateTime\"}, {\"name\": \"remarks\", \"aliasName\": \"remarks\"}, {\"name\": \"del_flag\", \"aliasName\": \"delFlag\"}, {\"name\": \"role_id\", \"aliasName\": \"roleId\"}, {\"name\": \"user_id\", \"aliasName\": \"userId\"}]}], \"pageParamName\": {\"pageNo\": \"page\", \"pageSize\": \"limit\"}, \"orderSelectList\": [], \"whereSelectList\": [{\"field\": \"role_id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"roleId\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}, {\"field\": \"user_id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"userId\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}, {\"id\": 1755477690592, \"name\": \"searchByUserId\", \"type\": \"SimpleQuery\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"log.info(\\\"-----searchyUserId------params:{}\\\",params);\", \"detail\": {\"isPage\": false, \"rawScript\": \"select <br/>&emsp;&emsp;role_id as roleId,<br/>&emsp;&emsp;user_id as userId<br/> from <br/>&emsp;&emsp;business_user_role\\n       <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>\\n       &emsp;&emsp;[[AND user_id = \'{{userId}}\']] <br/><br/><br/>\", \"actionType\": \"select\", \"saveScript\": \"select role_id as roleId,user_id as userId from business_user_role\\n        where del_flag = 0 \\n       [[AND user_id = \'{{userId}}\']] \", \"fieldSelected\": [{\"table\": \"business_user_role\", \"fields\": [\"role_id\", \"user_id\"], \"isExpand\": false, \"isSelectAllField\": false, \"fieldAliasNameMapArray\": [{\"name\": \"role_id\", \"aliasName\": \"roleId\"}, {\"name\": \"user_id\", \"aliasName\": \"userId\"}]}], \"pageParamName\": {\"pageNo\": \"page\", \"pageSize\": \"limit\"}, \"orderSelectList\": [], \"whereSelectList\": [{\"field\": \"user_id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"userId\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}, {\"id\": 1755478646389, \"name\": \"deleteByRoleId\", \"type\": \"SimpleSoftDelete\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"update <br/>&emsp;&emsp;business_user_role <br/>set <br/>&emsp;&emsp;del_flag = 1 <br/>where <br/>&emsp;&emsp;del_flag = 0 <br/>&emsp;&emsp;[[AND role_id = \'{{roleId}}\']] <br/>\", \"actionType\": \"delete\", \"saveScript\": \"update business_user_role set del_flag = 1 where del_flag = 0 [[AND role_id = \'{{roleId}}\']] \", \"physicsDelete\": false, \"whereSelectList\": [{\"field\": \"role_id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"roleId\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}]}', '3', 'BusinessUserRoleModel', '2025-08-14 10:45:41', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 0, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('2335c11cd9e24300b8c3d4b62e1fde9b', 'f162486e13fc46c08e1fe95ce88e279f', '000000000000000000000000000000', NULL, '1', '接口', '2025-08-20 09:31:00', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 0, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('25b34f0e7ccd4b8890b0cc549008ea85', 'f41197964a8a4305853b766532a4db0f', '000000000000000000000000000000', '{\"action\": \"addGroovy\", \"modelName\": \"BusinessRoleResourceModel\"}', '2', '/business-role-resource/add', '2025-08-19 14:54:57', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 0, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('31fe1f4621434cb69240537d2ab8d97d', 'a906a8d33e2e4f5294da872c7a9750a3', '000000000000000000000000000000', '{\"action\": \"detailDict\", \"modelName\": \"DatadictModel\"}', '2', '/data-dict/detail', '2025-08-20 10:40:58', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 0, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('391d8ad8037e4e1c84f3ed026705c6b9', '090a47673a014534b64f52a5dee605a1', '000000000000000000000000000000', '{\"action\": \"addGroovy\", \"modelName\": \"BusinessUserRoleModel\"}', '2', '/business-user-role/add', '2025-08-14 10:48:28', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 0, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('3a0f1c7ed5ac4bffa5ae919c038e630f', 'be9359e2e0cc44978cf409ba32751329', '000000000000000000000000000000', '{\"field\": [{\"id\": 1755067037446, \"name\": \"id\", \"sort\": 0, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"主键id\", \"required\": true, \"aliasName\": \"id\", \"maxLength\": 36, \"primaryKey\": true}, {\"id\": 1755067037447, \"name\": \"create_by\", \"sort\": 1, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"创建人\", \"aliasName\": \"createBy\", \"maxLength\": 36, \"primaryKey\": false}, {\"id\": 1755067037448, \"name\": \"create_time\", \"sort\": 2, \"type\": \"datetime\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"创建时间\", \"aliasName\": \"createTime\", \"maxLength\": 1, \"primaryKey\": false, \"defaultValue\": \"CURRENT_TIMESTAMP\", \"updateByCurrentTime\": true}, {\"id\": 1755067037449, \"name\": \"update_by\", \"sort\": 3, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"更新人\", \"aliasName\": \"updateBy\", \"maxLength\": 36, \"primaryKey\": false}, {\"id\": 1755067037450, \"name\": \"update_time\", \"sort\": 4, \"type\": \"datetime\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"更新时间\", \"aliasName\": \"updateTime\", \"maxLength\": 1, \"primaryKey\": false, \"defaultValue\": \"CURRENT_TIMESTAMP\"}, {\"id\": 1755067037451, \"name\": \"remarks\", \"sort\": 5, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"备注\", \"aliasName\": \"remarks\", \"maxLength\": 255, \"primaryKey\": false}, {\"id\": 1755067037452, \"name\": \"del_flag\", \"sort\": 6, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"删除标识（0：未删除 1：已删除）\", \"aliasName\": \"delFlag\", \"maxLength\": 1, \"primaryKey\": false, \"defaultValue\": \"0\"}, {\"id\": 1755067098098, \"name\": \"account\", \"sort\": 7, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"default\": \"\", \"required\": false, \"aliasName\": \"account\", \"maxLength\": 32, \"primaryKey\": false}, {\"id\": 1755067109883, \"name\": \"password\", \"sort\": 8, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"default\": \"\", \"required\": false, \"aliasName\": \"password\", \"maxLength\": 32, \"primaryKey\": false}, {\"id\": 1755067119526, \"name\": \"mobile\", \"sort\": 9, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"default\": \"\", \"required\": false, \"aliasName\": \"mobile\", \"maxLength\": 32, \"primaryKey\": false}, {\"id\": 1755067131771, \"name\": \"sex\", \"sort\": 10, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"0:男1:女\", \"default\": \"\", \"required\": false, \"aliasName\": \"sex\", \"maxLength\": 1, \"primaryKey\": false}, {\"id\": 1755067166946, \"name\": \"name\", \"sort\": 11, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"姓名\", \"default\": \"\", \"required\": false, \"aliasName\": \"name\", \"maxLength\": 32, \"primaryKey\": false}, {\"id\": 1755067200359, \"name\": \"age\", \"sort\": 12, \"type\": \"int\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"default\": \"\", \"required\": false, \"aliasName\": \"age\", \"maxLength\": 255, \"primaryKey\": false}], \"table\": {\"name\": \"business_user\", \"engine\": \"InnoDB\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"aliasName\": \"\", \"rowFormat\": \"DYNAMIC\"}, \"action\": [{\"id\": 1755067282021, \"name\": \"list\", \"type\": \"SimpleQuery\", \"after\": \"log.info(\\\"response---->{}\\\",params)\\nparams.response.rows.each{\\n    def userParam = JSONUtil.createObj();\\n    userParam.userId = it.id;\\n    def userRoleResult = BusinessUserRoleModel.searchByUserId(userParam);\\n    def roleList = new LinkedList<>();\\n    userRoleResult.each{\\n        roleList.add(it.roleId);\\n    }\\n    if(roleList){\\n        it.roleList = String.join(\\\",\\\",roleList);\\n    }\\n}\\n\", \"label\": \"\", \"before\": \"log.info(\\\"---------before-------params:{},currentUserId:{}\\\",params,currentUserId);\\nparams.id = currentUserId;\\nlog.info(\\\"---------after-------params:{},currentUserId:{}\\\",params,currentUserId);\\n\", \"detail\": {\"isPage\": true, \"rawScript\": \"select <br/>&emsp;&emsp;id as id,<br/>&emsp;&emsp;create_by as createBy,<br/>&emsp;&emsp;date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,<br/>&emsp;&emsp;update_by as updateBy,<br/>&emsp;&emsp;date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,<br/>&emsp;&emsp;remarks as remarks,<br/>&emsp;&emsp;del_flag as delFlag,<br/>&emsp;&emsp;account as account,<br/>&emsp;&emsp;password as password,<br/>&emsp;&emsp;mobile as mobile,<br/>&emsp;&emsp;sex as sex,<br/>&emsp;&emsp;name as name,<br/>&emsp;&emsp;age as age<br/> from <br/>&emsp;&emsp;business_user\\n       <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>\\n       &emsp;&emsp;[[AND account LIKE \'%{{account}}%\']] <br/> &emsp;&emsp;[[AND name LIKE \'%{{name}}%\']] <br/>order by <br/>&emsp;&emsp;create_time DESC<br/>\", \"actionType\": \"select\", \"saveScript\": \"select id as id,create_by as createBy,date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,update_by as updateBy,date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,remarks as remarks,del_flag as delFlag,account as account,password as password,mobile as mobile,sex as sex,name as name,age as age from business_user\\n        where del_flag = 0 \\n       [[AND account LIKE \'%{{account}}%\']]  [[AND name LIKE \'%{{name}}%\']] order by create_time DESC\", \"fieldSelected\": [{\"table\": \"business_user\", \"fields\": [\"id\", \"create_by\", \"create_time\", \"update_by\", \"update_time\", \"remarks\", \"del_flag\", \"account\", \"password\", \"mobile\", \"sex\", \"name\", \"age\"], \"isExpand\": false, \"isSelectAllField\": true, \"fieldAliasNameMapArray\": [{\"name\": \"id\", \"aliasName\": \"id\"}, {\"name\": \"create_by\", \"aliasName\": \"createBy\"}, {\"name\": \"create_time\", \"aliasName\": \"createTime\"}, {\"name\": \"update_by\", \"aliasName\": \"updateBy\"}, {\"name\": \"update_time\", \"aliasName\": \"updateTime\"}, {\"name\": \"remarks\", \"aliasName\": \"remarks\"}, {\"name\": \"del_flag\", \"aliasName\": \"delFlag\"}, {\"name\": \"account\", \"aliasName\": \"account\"}, {\"name\": \"password\", \"aliasName\": \"password\"}, {\"name\": \"mobile\", \"aliasName\": \"mobile\"}, {\"name\": \"sex\", \"aliasName\": \"sex\"}, {\"name\": \"name\", \"aliasName\": \"name\"}, {\"name\": \"age\", \"aliasName\": \"age\"}]}], \"pageParamName\": {\"pageNo\": \"page\", \"pageSize\": \"perPage\"}, \"orderSelectList\": [{\"field\": \"create_time\", \"orderType\": \"DESC\"}], \"whereSelectList\": [{\"field\": \"account\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"account\", \"valueB\": \"\", \"operator\": \"LIKE\", \"isParamName\": true}, {\"field\": \"name\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"name\", \"valueB\": \"\", \"operator\": \"LIKE\", \"isParamName\": true}]}}, {\"id\": 1755077010159, \"name\": \"add\", \"type\": \"SimpleInsert\", \"after\": \"\", \"label\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"insert into <br/>&emsp;&emsp;business_user ( id, create_by, update_by, account, password, mobile, sex, name, age, remarks ) <br/>values <br/>&emsp;&emsp;( \'{{id}}\' , \'{{createBy}}\' , \'{{updateBy}}\' , \'{{account}}\' , \'{{password}}\' , \'{{mobile}}\' , \'{{sex}}\' , \'{{name}}\' , \'{{age}}\' , \'{{remarks}}\' )\", \"actionType\": \"insert\", \"saveScript\": \"insert into business_user ( id, create_by, update_by, account, password, mobile, sex, name, age, remarks ) values ( \'{{id}}\' , \'{{createBy}}\' , \'{{updateBy}}\' , \'{{account}}\' , \'{{password}}\' , \'{{mobile}}\' , \'{{sex}}\' , \'{{name}}\' , \'{{age}}\' , \'{{remarks}}\' )\", \"insertFieldList\": [{\"label\": \"id(主键id)\", \"value\": \"id\", \"aliasName\": \"id\", \"isParamName\": true}, {\"label\": \"create_by(创建人)\", \"value\": \"create_by\", \"aliasName\": \"createBy\", \"isParamName\": true}, {\"label\": \"create_time(创建时间)\", \"value\": \"create_time\", \"aliasName\": \"createTime\", \"isParamName\": true}, {\"label\": \"update_by(更新人)\", \"value\": \"update_by\", \"aliasName\": \"updateBy\", \"isParamName\": true}, {\"label\": \"update_time(更新时间)\", \"value\": \"update_time\", \"aliasName\": \"updateTime\", \"isParamName\": true}, {\"label\": \"remarks(备注)\", \"value\": \"remarks\", \"aliasName\": \"remarks\", \"isParamName\": true}, {\"label\": \"del_flag(删除标识（0：未删除 1：已删除）)\", \"value\": \"del_flag\", \"aliasName\": \"delFlag\", \"isParamName\": true}, {\"label\": \"account\", \"value\": \"account\", \"aliasName\": \"account\", \"isParamName\": true}, {\"label\": \"password\", \"value\": \"password\", \"aliasName\": \"password\", \"isParamName\": true}, {\"label\": \"mobile\", \"value\": \"mobile\", \"aliasName\": \"mobile\", \"isParamName\": true}, {\"label\": \"sex(0:男1:女)\", \"value\": \"sex\", \"aliasName\": \"sex\", \"isParamName\": true}, {\"label\": \"name(姓名)\", \"value\": \"name\", \"aliasName\": \"name\", \"isParamName\": true}, {\"label\": \"age\", \"value\": \"age\", \"aliasName\": \"age\", \"isParamName\": true}], \"whereSelectList\": [], \"allInsertCheckBox\": false, \"insertCheckBoxList\": [\"id\", \"create_by\", \"update_by\", \"account\", \"password\", \"mobile\", \"sex\", \"name\", \"age\", \"remarks\"]}}, {\"id\": 1755495494423, \"name\": \"delete\", \"type\": \"SimpleSoftDelete\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"update <br/>&emsp;&emsp;business_user <br/>set <br/>&emsp;&emsp;del_flag = 1 <br/>where <br/>&emsp;&emsp;del_flag = 0 <br/>&emsp;&emsp;[[AND id = \'{{id}}\']] <br/>\", \"actionType\": \"delete\", \"saveScript\": \"update business_user set del_flag = 1 where del_flag = 0 [[AND id = \'{{id}}\']] \", \"physicsDelete\": false, \"whereSelectList\": [{\"field\": \"id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"id\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}, {\"id\": 1755498137561, \"name\": \"edit\", \"type\": \"SimpleUpdate\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"update <br/>&emsp;&emsp;business_user <br/>set <br/>&emsp;&emsp;[[create_by = \'{{createBy}}\',]] <br/>&emsp;&emsp;[[create_time = \'{{createTime}}\',]] <br/>&emsp;&emsp;[[update_by = \'{{updateBy}}\',]] <br/>&emsp;&emsp;[[update_time = \'{{updateTime}}\',]] <br/>&emsp;&emsp;[[remarks = \'{{remarks}}\',]] <br/>&emsp;&emsp;[[del_flag = \'{{delFlag}}\',]] <br/>&emsp;&emsp;[[account = \'{{account}}\',]] <br/>&emsp;&emsp;[[password = \'{{password}}\',]] <br/>&emsp;&emsp;[[mobile = \'{{mobile}}\',]] <br/>&emsp;&emsp;[[sex = \'{{sex}}\',]] <br/>&emsp;&emsp;[[name = \'{{name}}\',]] <br/>&emsp;&emsp;[[age = \'{{age}}\',]] <br/> &emsp;&emsp;del_flag = 0 <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>&emsp;&emsp;[[AND id = \'{{id}}\']] <br/>\", \"actionType\": \"update\", \"saveScript\": \"update business_user set [[create_by = \'{{createBy}}\',]] [[create_time = \'{{createTime}}\',]] [[update_by = \'{{updateBy}}\',]] [[update_time = \'{{updateTime}}\',]] [[remarks = \'{{remarks}}\',]] [[del_flag = \'{{delFlag}}\',]] [[account = \'{{account}}\',]] [[password = \'{{password}}\',]] [[mobile = \'{{mobile}}\',]] [[sex = \'{{sex}}\',]] [[name = \'{{name}}\',]] [[age = \'{{age}}\',]]  del_flag = 0  where del_flag = 0 [[AND id = \'{{id}}\']] \", \"upDateFieldList\": [{\"label\": \"id(主键id)\", \"value\": \"id\", \"aliasName\": \"id\", \"isParamName\": true}, {\"label\": \"create_by(创建人)\", \"value\": \"create_by\", \"aliasName\": \"createBy\", \"isParamName\": true}, {\"label\": \"create_time(创建时间)\", \"value\": \"create_time\", \"aliasName\": \"createTime\", \"isParamName\": true}, {\"label\": \"update_by(更新人)\", \"value\": \"update_by\", \"aliasName\": \"updateBy\", \"isParamName\": true}, {\"label\": \"update_time(更新时间)\", \"value\": \"update_time\", \"aliasName\": \"updateTime\", \"isParamName\": true}, {\"label\": \"remarks(备注)\", \"value\": \"remarks\", \"aliasName\": \"remarks\", \"isParamName\": true}, {\"label\": \"del_flag(删除标识（0：未删除 1：已删除）)\", \"value\": \"del_flag\", \"aliasName\": \"delFlag\", \"isParamName\": true}, {\"label\": \"account\", \"value\": \"account\", \"aliasName\": \"account\", \"isParamName\": true}, {\"label\": \"password\", \"value\": \"password\", \"aliasName\": \"password\", \"isParamName\": true}, {\"label\": \"mobile\", \"value\": \"mobile\", \"aliasName\": \"mobile\", \"isParamName\": true}, {\"label\": \"sex(0:男1:女)\", \"value\": \"sex\", \"aliasName\": \"sex\", \"isParamName\": true}, {\"label\": \"name(姓名)\", \"value\": \"name\", \"aliasName\": \"name\", \"isParamName\": true}, {\"label\": \"age\", \"value\": \"age\", \"aliasName\": \"age\", \"isParamName\": true}], \"whereSelectList\": [{\"field\": \"id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"id\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}], \"updateCheckBoxList\": [\"create_by\", \"create_time\", \"update_by\", \"update_time\", \"remarks\", \"del_flag\", \"account\", \"password\", \"mobile\", \"sex\", \"name\", \"age\"]}}]}', '3', 'BusinessUserModel', '2025-08-13 14:37:35', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 1, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('55fea895f5d749d59b42f7ccc9a820b5', 'f162486e13fc46c08e1fe95ce88e279f', '000000000000000000000000000000', NULL, '1', '模型', '2025-08-20 09:31:09', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 1, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('5bc783f7c9524645bb3e54e1ecee318d', '090a47673a014534b64f52a5dee605a1', '000000000000000000000000000000', '{\"action\": \"edit\", \"modelName\": \"BusinessUserModel\"}', '2', '/business-user/edit', '2025-08-18 14:24:07', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 1, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('5c3fc3c40d9d4f918fb10cbce75c5441', 'f41197964a8a4305853b766532a4db0f', '000000000000000000000000000000', '{\"action\": \"edit\", \"modelName\": \"BusinessRoleModel\"}', '2', '/business-role/edit', '2025-08-19 10:48:27', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 2, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('5d3fe37226644eac8b1abb4aa1ed28c2', NULL, '000000000000000000000000000000', '{}', '1', '测试', '2025-08-29 23:30:02', '2025-08-29 23:32:33', '0', NULL, NULL, NULL, 1, NULL);
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('5f32fec88749487da8f9d08594090f76', '090a47673a014534b64f52a5dee605a1', '000000000000000000000000000000', '{\"action\": \"delete\", \"modelName\": \"BusinessUserModel\"}', '2', '/business-user/delete', '2025-08-18 13:38:06', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 2, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('6358841caee4462a94f15b21c22f1793', '2335c11cd9e24300b8c3d4b62e1fde9b', '000000000000000000000000000000', '{\"action\": \"editDictItem\", \"modelName\": \"DataDictItemModel\"}', '2', '/data-dict-item/getByDictName', '2025-08-23 13:29:53', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 0, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('6ae890d0c73d4cd1b58156140fafeda5', '090a47673a014534b64f52a5dee605a1', '000000000000000000000000000000', '{\"action\": \"list\", \"modelName\": \"BusinessUserModel\"}', '2', '/business-user/list', '2025-08-13 14:43:17', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 3, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('6d72e9b98b19463685aa99c23fb446d8', '812d2b2603a24fc0b9a23641f60c2daf', '000000000000000000000000000000', '{\"field\": [{\"id\": 1755133987583, \"name\": \"id\", \"sort\": 0, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"主键id\", \"required\": true, \"aliasName\": \"id\", \"maxLength\": 36, \"primaryKey\": true}, {\"id\": 1755133987584, \"name\": \"create_by\", \"sort\": 1, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"创建人\", \"aliasName\": \"createBy\", \"maxLength\": 36, \"primaryKey\": false}, {\"id\": 1755133987585, \"name\": \"create_time\", \"sort\": 2, \"type\": \"datetime\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"创建时间\", \"aliasName\": \"createTime\", \"maxLength\": 0, \"primaryKey\": false, \"defaultValue\": \"CURRENT_TIMESTAMP\"}, {\"id\": 1755133987586, \"name\": \"update_by\", \"sort\": 3, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"更新人\", \"aliasName\": \"updateBy\", \"maxLength\": 36, \"primaryKey\": false}, {\"id\": 1755133987587, \"name\": \"update_time\", \"sort\": 4, \"type\": \"datetime\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"更新时间\", \"aliasName\": \"updateTime\", \"maxLength\": 0, \"primaryKey\": false, \"defaultValue\": \"CURRENT_TIMESTAMP\", \"updateByCurrentTime\": true}, {\"id\": 1755133987588, \"name\": \"remarks\", \"sort\": 5, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"备注\", \"aliasName\": \"remarks\", \"maxLength\": 255, \"primaryKey\": false}, {\"id\": 1755133987589, \"name\": \"del_flag\", \"sort\": 6, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"删除标识（0：未删除 1：已删除）\", \"aliasName\": \"delFlag\", \"maxLength\": 1, \"primaryKey\": false, \"defaultValue\": \"0\"}, {\"id\": 1755133999353, \"name\": \"name\", \"sort\": 7, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"required\": true, \"aliasName\": \"name\", \"maxLength\": 32, \"primaryKey\": false, \"defaultValue\": \"\"}], \"table\": {\"name\": \"business_role\", \"engine\": \"InnoDB\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"aliasName\": \"\", \"rowFormat\": \"DYNAMIC\"}, \"action\": [{\"id\": 1755134014299, \"name\": \"list\", \"type\": \"SimpleQuery\", \"after\": \"log.info(\\\"-----------it-{}\\\",params)\\nparams.response.rows.each{\\n    def roleId = it.id;\\n    def roleParam = JSONUtil.createObj();\\n    roleParam.roleId = roleId;\\n    def roleResourceResult = BusinessRoleResourceModel.list(roleParam);\\n    if(roleResourceResult){\\n        def resourceIdList = new LinkedList<>();\\n        roleResourceResult.each{\\n            resourceIdList.add(it.resourceId);\\n        }\\n        it.resourceList = String.join(\\\",\\\",resourceIdList);\\n    }\\n}\", \"label\": \"\", \"before\": \"\", \"detail\": {\"isPage\": true, \"rawScript\": \"select <br/>&emsp;&emsp;id as id,<br/>&emsp;&emsp;create_by as createBy,<br/>&emsp;&emsp;date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,<br/>&emsp;&emsp;update_by as updateBy,<br/>&emsp;&emsp;date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,<br/>&emsp;&emsp;remarks as remarks,<br/>&emsp;&emsp;del_flag as delFlag,<br/>&emsp;&emsp;name as name<br/> from <br/>&emsp;&emsp;business_role\\n       <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>\\n       &emsp;&emsp;[[AND name LIKE \'%{{name}}%\']] <br/>order by <br/>&emsp;&emsp;create_time DESC<br/>\", \"actionType\": \"select\", \"saveScript\": \"select id as id,create_by as createBy,date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,update_by as updateBy,date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,remarks as remarks,del_flag as delFlag,name as name from business_role\\n        where del_flag = 0 \\n       [[AND name LIKE \'%{{name}}%\']] order by create_time DESC\", \"fieldSelected\": [{\"table\": \"business_role\", \"fields\": [\"id\", \"create_by\", \"create_time\", \"update_by\", \"update_time\", \"remarks\", \"del_flag\", \"name\"], \"isExpand\": false, \"isSelectAllField\": true, \"fieldAliasNameMapArray\": [{\"name\": \"id\", \"aliasName\": \"id\"}, {\"name\": \"create_by\", \"aliasName\": \"createBy\"}, {\"name\": \"create_time\", \"aliasName\": \"createTime\"}, {\"name\": \"update_by\", \"aliasName\": \"updateBy\"}, {\"name\": \"update_time\", \"aliasName\": \"updateTime\"}, {\"name\": \"remarks\", \"aliasName\": \"remarks\"}, {\"name\": \"del_flag\", \"aliasName\": \"delFlag\"}, {\"name\": \"name\", \"aliasName\": \"name\"}]}], \"pageParamName\": {\"pageNo\": \"page\", \"pageSize\": \"perPage\"}, \"orderSelectList\": [{\"field\": \"create_time\", \"orderType\": \"DESC\"}], \"whereSelectList\": [{\"field\": \"name\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"name\", \"valueB\": \"\", \"operator\": \"LIKE\", \"isParamName\": true}]}}, {\"id\": 1755571576702, \"name\": \"add\", \"type\": \"SimpleInsert\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"insert into <br/>&emsp;&emsp;business_role ( id, update_by, name, create_by, remarks ) <br/>values <br/>&emsp;&emsp;( \'{{id}}\' , \'{{updateBy}}\' , \'{{name}}\' , \'{{createBy}}\' , \'{{remarks}}\' )\", \"actionType\": \"insert\", \"saveScript\": \"insert into business_role ( id, update_by, name, create_by, remarks ) values ( \'{{id}}\' , \'{{updateBy}}\' , \'{{name}}\' , \'{{createBy}}\' , \'{{remarks}}\' )\", \"insertFieldList\": [{\"label\": \"id(主键id)\", \"value\": \"id\", \"aliasName\": \"id\", \"isParamName\": true}, {\"label\": \"create_by(创建人)\", \"value\": \"create_by\", \"aliasName\": \"createBy\", \"isParamName\": true}, {\"label\": \"create_time(创建时间)\", \"value\": \"create_time\", \"aliasName\": \"createTime\", \"isParamName\": true}, {\"label\": \"update_by(更新人)\", \"value\": \"update_by\", \"aliasName\": \"updateBy\", \"isParamName\": true}, {\"label\": \"update_time(更新时间)\", \"value\": \"update_time\", \"aliasName\": \"updateTime\", \"isParamName\": true}, {\"label\": \"remarks(备注)\", \"value\": \"remarks\", \"aliasName\": \"remarks\", \"isParamName\": true}, {\"label\": \"del_flag(删除标识（0：未删除 1：已删除）)\", \"value\": \"del_flag\", \"aliasName\": \"delFlag\", \"isParamName\": true}, {\"label\": \"name\", \"value\": \"name\", \"aliasName\": \"name\", \"isParamName\": true}], \"whereSelectList\": [], \"allInsertCheckBox\": false, \"insertCheckBoxList\": [\"id\", \"update_by\", \"name\", \"create_by\", \"remarks\"]}}, {\"id\": 1755571607672, \"name\": \"edit\", \"type\": \"SimpleUpdate\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"update <br/>&emsp;&emsp;business_role <br/>set <br/>&emsp;&emsp;[[update_by = \'{{updateBy}}\',]] <br/>&emsp;&emsp;[[remarks = \'{{remarks}}\',]] <br/>&emsp;&emsp;[[del_flag = \'{{delFlag}}\',]] <br/>&emsp;&emsp;[[name = \'{{name}}\',]] <br/> &emsp;&emsp;del_flag = 0 <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>&emsp;&emsp;[[AND id = \'{{id}}\']] <br/>\", \"actionType\": \"update\", \"saveScript\": \"update business_role set [[update_by = \'{{updateBy}}\',]] [[remarks = \'{{remarks}}\',]] [[del_flag = \'{{delFlag}}\',]] [[name = \'{{name}}\',]]  del_flag = 0  where del_flag = 0 [[AND id = \'{{id}}\']] \", \"upDateFieldList\": [{\"label\": \"id(主键id)\", \"value\": \"id\", \"aliasName\": \"id\", \"isParamName\": true}, {\"label\": \"create_by(创建人)\", \"value\": \"create_by\", \"aliasName\": \"createBy\", \"isParamName\": true}, {\"label\": \"create_time(创建时间)\", \"value\": \"create_time\", \"aliasName\": \"createTime\", \"isParamName\": true}, {\"label\": \"update_by(更新人)\", \"value\": \"update_by\", \"aliasName\": \"updateBy\", \"isParamName\": true}, {\"label\": \"update_time(更新时间)\", \"value\": \"update_time\", \"aliasName\": \"updateTime\", \"isParamName\": true}, {\"label\": \"remarks(备注)\", \"value\": \"remarks\", \"aliasName\": \"remarks\", \"isParamName\": true}, {\"label\": \"del_flag(删除标识（0：未删除 1：已删除）)\", \"value\": \"del_flag\", \"aliasName\": \"delFlag\", \"isParamName\": true}, {\"label\": \"name\", \"value\": \"name\", \"aliasName\": \"name\", \"isParamName\": true}], \"whereSelectList\": [{\"field\": \"id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"id\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}], \"updateCheckBoxList\": [\"update_by\", \"remarks\", \"del_flag\", \"name\"]}}, {\"id\": 1755571647461, \"name\": \"delete\", \"type\": \"SimpleSoftDelete\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"def deleteResoureRoleParam = JSONUtil.createObj();\\ndeleteResoureRoleParam.roleId = params.id;\\nBusinessRoleResourceModel.delete(deleteResoureRoleParam);\", \"detail\": {\"rawScript\": \"update <br/>&emsp;&emsp;business_role <br/>set <br/>&emsp;&emsp;del_flag = 1 <br/>where <br/>&emsp;&emsp;del_flag = 0 <br/>&emsp;&emsp;[[AND id = \'{{id}}\']] <br/>\", \"actionType\": \"delete\", \"saveScript\": \"update business_role set del_flag = 1 where del_flag = 0 [[AND id = \'{{id}}\']] \", \"physicsDelete\": false, \"whereSelectList\": [{\"field\": \"id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"id\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}]}', '3', 'BusinessRoleModel', '2025-08-14 09:13:07', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 0, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('6e6537a8d9694ea69166c877e7c50df3', '5d3fe37226644eac8b1abb4aa1ed28c2', '000000000000000000000000000000', '{\"action\": \"addGroovy\", \"modelName\": \"BusinessUserRoleModel\"}', '2', '/321/32', '2025-08-30 19:10:52', '2025-08-30 19:10:52', '0', NULL, NULL, NULL, 0, NULL);
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('7097606e4f984cdb9d2be5392a2cd016', 'f41197964a8a4305853b766532a4db0f', '000000000000000000000000000000', '{\"action\": \"add\", \"modelName\": \"BusinessRoleModel\"}', '2', '/business-role/add', '2025-08-19 10:48:13', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 3, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('783a2d7948334b1d9a427724b287d5e6', '812d2b2603a24fc0b9a23641f60c2daf', '000000000000000000000000000000', '{\"field\": [{\"id\": 1755586261953, \"name\": \"id\", \"sort\": 0, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"主键id\", \"required\": true, \"aliasName\": \"id\", \"maxLength\": 36, \"primaryKey\": true}, {\"id\": 1755586261954, \"name\": \"create_by\", \"sort\": 1, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"创建人\", \"aliasName\": \"createBy\", \"maxLength\": 36, \"primaryKey\": false}, {\"id\": 1755586261955, \"name\": \"create_time\", \"sort\": 2, \"type\": \"datetime\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"创建时间\", \"aliasName\": \"createTime\", \"maxLength\": 0, \"primaryKey\": false, \"defaultValue\": \"CURRENT_TIMESTAMP\"}, {\"id\": 1755586261956, \"name\": \"update_by\", \"sort\": 3, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"更新人\", \"aliasName\": \"updateBy\", \"maxLength\": 36, \"primaryKey\": false}, {\"id\": 1755586261957, \"name\": \"update_time\", \"sort\": 4, \"type\": \"datetime\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"更新时间\", \"aliasName\": \"updateTime\", \"maxLength\": 0, \"primaryKey\": false, \"defaultValue\": \"CURRENT_TIMESTAMP\", \"updateByCurrentTime\": true}, {\"id\": 1755586261958, \"name\": \"remarks\", \"sort\": 5, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"备注\", \"aliasName\": \"remarks\", \"maxLength\": 255, \"primaryKey\": false}, {\"id\": 1755586261959, \"name\": \"del_flag\", \"sort\": 6, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"删除标识（0：未删除 1：已删除）\", \"aliasName\": \"delFlag\", \"maxLength\": 1, \"primaryKey\": false, \"defaultValue\": \"0\"}, {\"id\": 1755586275970, \"name\": \"role_id\", \"sort\": 7, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"required\": false, \"aliasName\": \"roleId\", \"maxLength\": 32, \"primaryKey\": false, \"defaultValue\": \"\"}, {\"id\": 1755586286503, \"name\": \"resource_id\", \"sort\": 8, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"required\": false, \"aliasName\": \"resourceId\", \"maxLength\": 32, \"primaryKey\": false, \"defaultValue\": \"\"}], \"table\": {\"name\": \"business_role_resource\", \"engine\": \"InnoDB\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"aliasName\": \"\", \"rowFormat\": \"DYNAMIC\"}, \"action\": [{\"id\": 1755586304800, \"name\": \"add\", \"type\": \"SimpleInsert\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"insert into <br/>&emsp;&emsp;business_role_resource ( id, role_id, resource_id ) <br/>values <br/>&emsp;&emsp;( \'{{id}}\' , \'{{roleId}}\' , \'{{resourceId}}\' )\", \"actionType\": \"insert\", \"saveScript\": \"insert into business_role_resource ( id, role_id, resource_id ) values ( \'{{id}}\' , \'{{roleId}}\' , \'{{resourceId}}\' )\", \"insertFieldList\": [{\"label\": \"id(主键id)\", \"value\": \"id\", \"aliasName\": \"id\", \"isParamName\": true}, {\"label\": \"create_by(创建人)\", \"value\": \"create_by\", \"aliasName\": \"createBy\", \"isParamName\": true}, {\"label\": \"create_time(创建时间)\", \"value\": \"create_time\", \"aliasName\": \"createTime\", \"isParamName\": true}, {\"label\": \"update_by(更新人)\", \"value\": \"update_by\", \"aliasName\": \"updateBy\", \"isParamName\": true}, {\"label\": \"update_time(更新时间)\", \"value\": \"update_time\", \"aliasName\": \"updateTime\", \"isParamName\": true}, {\"label\": \"remarks(备注)\", \"value\": \"remarks\", \"aliasName\": \"remarks\", \"isParamName\": true}, {\"label\": \"del_flag(删除标识（0：未删除 1：已删除）)\", \"value\": \"del_flag\", \"aliasName\": \"delFlag\", \"isParamName\": true}, {\"label\": \"role_id\", \"value\": \"role_id\", \"aliasName\": \"roleId\", \"isParamName\": true}, {\"label\": \"resource_id\", \"value\": \"resource_id\", \"aliasName\": \"resourceId\", \"isParamName\": true}], \"whereSelectList\": [], \"allInsertCheckBox\": false, \"insertCheckBoxList\": [\"id\", \"role_id\", \"resource_id\"]}}, {\"id\": 1755586334104, \"name\": \"edit\", \"type\": \"SimpleUpdate\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"update <br/>&emsp;&emsp;business_role_resource <br/>set <br/>&emsp;&emsp;[[role_id = \'{{roleId}}\',]] <br/>&emsp;&emsp;[[resource_id = \'{{resourceId}}\',]] <br/> &emsp;&emsp;del_flag = 0 <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>&emsp;&emsp;[[AND id = \'{{id}}\']] <br/>\", \"actionType\": \"update\", \"saveScript\": \"update business_role_resource set [[role_id = \'{{roleId}}\',]] [[resource_id = \'{{resourceId}}\',]]  del_flag = 0  where del_flag = 0 [[AND id = \'{{id}}\']] \", \"upDateFieldList\": [{\"label\": \"id(主键id)\", \"value\": \"id\", \"aliasName\": \"id\", \"isParamName\": true}, {\"label\": \"create_by(创建人)\", \"value\": \"create_by\", \"aliasName\": \"createBy\", \"isParamName\": true}, {\"label\": \"create_time(创建时间)\", \"value\": \"create_time\", \"aliasName\": \"createTime\", \"isParamName\": true}, {\"label\": \"update_by(更新人)\", \"value\": \"update_by\", \"aliasName\": \"updateBy\", \"isParamName\": true}, {\"label\": \"update_time(更新时间)\", \"value\": \"update_time\", \"aliasName\": \"updateTime\", \"isParamName\": true}, {\"label\": \"remarks(备注)\", \"value\": \"remarks\", \"aliasName\": \"remarks\", \"isParamName\": true}, {\"label\": \"del_flag(删除标识（0：未删除 1：已删除）)\", \"value\": \"del_flag\", \"aliasName\": \"delFlag\", \"isParamName\": true}, {\"label\": \"role_id\", \"value\": \"role_id\", \"aliasName\": \"roleId\", \"isParamName\": true}, {\"label\": \"resource_id\", \"value\": \"resource_id\", \"aliasName\": \"resourceId\", \"isParamName\": true}], \"whereSelectList\": [{\"field\": \"id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"id\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}], \"updateCheckBoxList\": [\"role_id\", \"resource_id\"]}}, {\"id\": 1755586357840, \"name\": \"delete\", \"type\": \"SimpleSoftDelete\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"update <br/>&emsp;&emsp;business_role_resource <br/>set <br/>&emsp;&emsp;del_flag = 1 <br/>where <br/>&emsp;&emsp;del_flag = 0 <br/>&emsp;&emsp;[[AND role_id = \'{{roleId}}\']] <br/> &emsp;&emsp;[[AND resource_id = \'{{resourceId}}\']] <br/>\", \"actionType\": \"delete\", \"saveScript\": \"update business_role_resource set del_flag = 1 where del_flag = 0 [[AND role_id = \'{{roleId}}\']]  [[AND resource_id = \'{{resourceId}}\']] \", \"physicsDelete\": false, \"whereSelectList\": [{\"field\": \"role_id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"roleId\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}, {\"field\": \"resource_id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"resourceId\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}, {\"id\": 1755586415072, \"name\": \"list\", \"type\": \"SimpleQuery\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"isPage\": false, \"rawScript\": \"select <br/>&emsp;&emsp;role_id as roleId,<br/>&emsp;&emsp;resource_id as resourceId,<br/>&emsp;&emsp;id as id<br/> from <br/>&emsp;&emsp;business_role_resource\\n       <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>\\n       &emsp;&emsp;[[AND role_id = \'{{roleId}}\']] <br/> &emsp;&emsp;[[AND resource_id = \'{{resourceId}}\']] <br/><br/><br/>\", \"actionType\": \"select\", \"saveScript\": \"select role_id as roleId,resource_id as resourceId,id as id from business_role_resource\\n        where del_flag = 0 \\n       [[AND role_id = \'{{roleId}}\']]  [[AND resource_id = \'{{resourceId}}\']] \", \"fieldSelected\": [{\"table\": \"business_role_resource\", \"fields\": [\"role_id\", \"resource_id\", \"id\"], \"isExpand\": false, \"isSelectAllField\": false, \"fieldAliasNameMapArray\": [{\"name\": \"role_id\", \"aliasName\": \"roleId\"}, {\"name\": \"resource_id\", \"aliasName\": \"resourceId\"}, {\"name\": \"id\", \"aliasName\": \"id\"}]}], \"pageParamName\": {\"pageNo\": \"page\", \"pageSize\": \"limit\"}, \"orderSelectList\": [], \"whereSelectList\": [{\"field\": \"role_id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"roleId\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}, {\"field\": \"resource_id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"resourceId\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}, {\"id\": 1755586542076, \"name\": \"addGroovy\", \"type\": \"CustomScript\", \"after\": \"\", \"label\": \"\", \"shell\": \"//查询当前角色下已经存在的资源\\ndef resourceParam = JSONUtil.createObj();\\nresourceParam.roleId = params.roleId;\\ndef newResourceList = params.resourceList.split(\\\",\\\");\\ndef oldResourceList = BusinessRoleResourceModel.list(resourceParam);\\nlog.info(\\\"----------oldResourceList->{}\\\",oldResourceList);\\ndef rosourceIdList = new LinkedList<>();\\noldResourceList.each{\\n    rosourceIdList.add(it.resourceId);\\n}\\n\\nif(newResourceList){\\n    newResourceList.each{\\n        if(rosourceIdList.remove(it)){\\n            return true;\\n        }\\n        def addResourceRoleParam = JSONUtil.createObj();\\n        addResourceRoleParam.roleId = params.roleId;\\n        addResourceRoleParam.resourceId = it;\\n        BusinessRoleResourceModel.add(addResourceRoleParam);\\n    }\\n}\\nif(rosourceIdList){\\n    rosourceIdList.each{\\n        def deleteParam = JSONUtil.createObj();\\n        deleteParam.roleId = params.roleId;\\n        deleteParam.resourceId = it;\\n        BusinessRoleResourceModel.delete(deleteParam);\\n    }\\n}\", \"before\": \"\", \"detail\": {\"rawScript\": \"\", \"actionType\": \"\", \"saveScript\": \"\"}}]}', '3', 'BusinessRoleResourceModel', '2025-08-19 14:51:02', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 1, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('7d4f422c875d44638e037a2543d6dfc5', '090a47673a014534b64f52a5dee605a1', '000000000000000000000000000000', '{\"action\": \"add\", \"modelName\": \"BusinessUserModel\"}', '2', '/business-user/add', '2025-08-13 17:24:34', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 4, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('812d2b2603a24fc0b9a23641f60c2daf', 'b00a8e8268524c3eb4eeab9aee035dc1', '000000000000000000000000000000', NULL, '1', '模型', '2025-08-19 14:48:00', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 1, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('8b314ee80a0e4fb0991187027faebec9', 'a906a8d33e2e4f5294da872c7a9750a3', '000000000000000000000000000000', '{\"action\": \"addDict\", \"modelName\": \"DatadictModel\"}', '2', '/data-dict/add', '2025-08-19 16:15:20', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 3, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('8bb5306a9db14692a5b6468889e2eca3', 'c84bf3c76f7945acb42324703b0f182b', '000000000000000000000000000000', '{\"field\": [{\"id\": 1755590474661, \"name\": \"id\", \"sort\": 0, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"主键id\", \"required\": true, \"aliasName\": \"id\", \"maxLength\": 36, \"primaryKey\": true}, {\"id\": 1755590568181, \"name\": \"dict_label\", \"sort\": 1, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"required\": false, \"aliasName\": \"dictLabel\", \"maxLength\": 255, \"primaryKey\": false, \"defaultValue\": \"\"}, {\"id\": 1755590608768, \"name\": \"dict_name\", \"sort\": 2, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"required\": false, \"aliasName\": \"dictName\", \"maxLength\": 255, \"primaryKey\": false, \"defaultValue\": \"\"}, {\"id\": 1755590474662, \"name\": \"create_by\", \"sort\": 3, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"创建人\", \"aliasName\": \"createBy\", \"maxLength\": 36, \"primaryKey\": false}, {\"id\": 1755590474663, \"name\": \"create_time\", \"sort\": 4, \"type\": \"datetime\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"创建时间\", \"aliasName\": \"createTime\", \"maxLength\": 0, \"primaryKey\": false, \"defaultValue\": \"CURRENT_TIMESTAMP\"}, {\"id\": 1755590474664, \"name\": \"update_by\", \"sort\": 5, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"更新人\", \"aliasName\": \"updateBy\", \"maxLength\": 36, \"primaryKey\": false}, {\"id\": 1755590474665, \"name\": \"update_time\", \"sort\": 6, \"type\": \"datetime\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"更新时间\", \"aliasName\": \"updateTime\", \"maxLength\": 0, \"primaryKey\": false, \"defaultValue\": \"CURRENT_TIMESTAMP\", \"updateByCurrentTime\": true}, {\"id\": 1755590474666, \"name\": \"remarks\", \"sort\": 7, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"备注\", \"aliasName\": \"remarks\", \"maxLength\": 255, \"primaryKey\": false}, {\"id\": 1755590474667, \"name\": \"del_flag\", \"sort\": 8, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"删除标识（0：未删除 1：已删除）\", \"aliasName\": \"delFlag\", \"maxLength\": 1, \"primaryKey\": false, \"defaultValue\": \"0\"}], \"table\": {\"name\": \"data_dict\", \"engine\": \"InnoDB\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"aliasName\": \"\", \"rowFormat\": \"DYNAMIC\"}, \"action\": [{\"id\": 1755591766243, \"name\": \"queryDict\", \"type\": \"SimpleQuery\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"isPage\": true, \"rawScript\": \"select <br/>&emsp;&emsp;id as id,<br/>&emsp;&emsp;dict_label as dictLabel,<br/>&emsp;&emsp;dict_name as dictName,<br/>&emsp;&emsp;create_by as createBy,<br/>&emsp;&emsp;date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,<br/>&emsp;&emsp;update_by as updateBy,<br/>&emsp;&emsp;date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,<br/>&emsp;&emsp;remarks as remarks,<br/>&emsp;&emsp;del_flag as delFlag<br/> from <br/>&emsp;&emsp;data_dict\\n       <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>\\n       &emsp;&emsp;[[AND dict_label = \'{{dictLabel}}\']] <br/> &emsp;&emsp;[[AND dict_name = \'{{dictName}}\']] <br/><br/><br/>\", \"actionType\": \"select\", \"saveScript\": \"select id as id,dict_label as dictLabel,dict_name as dictName,create_by as createBy,date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,update_by as updateBy,date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,remarks as remarks,del_flag as delFlag from data_dict\\n        where del_flag = 0 \\n       [[AND dict_label = \'{{dictLabel}}\']]  [[AND dict_name = \'{{dictName}}\']] \", \"fieldSelected\": [{\"table\": \"data_dict\", \"fields\": [\"id\", \"dict_label\", \"dict_name\", \"create_by\", \"create_time\", \"update_by\", \"update_time\", \"remarks\", \"del_flag\"], \"isExpand\": false, \"isSelectAllField\": true, \"fieldAliasNameMapArray\": [{\"name\": \"id\", \"aliasName\": \"id\"}, {\"name\": \"dict_label\", \"aliasName\": \"dictLabel\"}, {\"name\": \"dict_name\", \"aliasName\": \"dictName\"}, {\"name\": \"create_by\", \"aliasName\": \"createBy\"}, {\"name\": \"create_time\", \"aliasName\": \"createTime\"}, {\"name\": \"update_by\", \"aliasName\": \"updateBy\"}, {\"name\": \"update_time\", \"aliasName\": \"updateTime\"}, {\"name\": \"remarks\", \"aliasName\": \"remarks\"}, {\"name\": \"del_flag\", \"aliasName\": \"delFlag\"}]}], \"pageParamName\": {\"pageNo\": \"page\", \"pageSize\": \"perPage\"}, \"orderSelectList\": [], \"whereSelectList\": [{\"field\": \"dict_label\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"dictLabel\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}, {\"field\": \"dict_name\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"dictName\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}, {\"id\": 1755591994856, \"name\": \"addDict\", \"type\": \"SimpleInsert\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"insert into <br/>&emsp;&emsp;data_dict ( dict_label, dict_name, del_flag, id ) <br/>values <br/>&emsp;&emsp;( \'{{dictLabel}}\' , \'{{dictName}}\' , \'0\' , \'{{id}}\' )\", \"actionType\": \"insert\", \"saveScript\": \"insert into data_dict ( dict_label, dict_name, del_flag, id ) values ( \'{{dictLabel}}\' , \'{{dictName}}\' , \'0\' , \'{{id}}\' )\", \"insertFieldList\": [{\"label\": \"id(主键id)\", \"value\": \"id\", \"aliasName\": \"id\", \"isParamName\": true}, {\"label\": \"dict_label\", \"value\": \"dict_label\", \"aliasName\": \"dictLabel\", \"isParamName\": true}, {\"label\": \"dict_name\", \"value\": \"dict_name\", \"aliasName\": \"dictName\", \"isParamName\": true}, {\"label\": \"create_by(创建人)\", \"value\": \"create_by\", \"aliasName\": \"createBy\", \"isParamName\": true}, {\"label\": \"create_time(创建时间)\", \"value\": \"create_time\", \"aliasName\": \"createTime\", \"isParamName\": true}, {\"label\": \"update_by(更新人)\", \"value\": \"update_by\", \"aliasName\": \"updateBy\", \"isParamName\": true}, {\"label\": \"update_time(更新时间)\", \"value\": \"update_time\", \"aliasName\": \"updateTime\", \"isParamName\": true}, {\"label\": \"remarks(备注)\", \"value\": \"remarks\", \"aliasName\": \"remarks\", \"isParamName\": true}, {\"label\": \"del_flag(删除标识（0：未删除 1：已删除）)\", \"value\": \"del_flag\", \"aliasName\": \"0\", \"isParamName\": false}], \"whereSelectList\": [], \"allInsertCheckBox\": false, \"insertCheckBoxList\": [\"dict_label\", \"dict_name\", \"del_flag\", \"id\"]}}, {\"id\": 1755656867569, \"name\": \"editDict\", \"type\": \"SimpleUpdate\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"update <br/>&emsp;&emsp;data_dict <br/>set <br/>&emsp;&emsp;[[dict_label = \'{{dictLabel}}\',]] <br/>&emsp;&emsp;[[dict_name = \'{{dictName}}\',]] <br/> &emsp;&emsp;del_flag = 0 <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>&emsp;&emsp;[[AND id = \'{{id}}\']] <br/>\", \"actionType\": \"update\", \"saveScript\": \"update data_dict set [[dict_label = \'{{dictLabel}}\',]] [[dict_name = \'{{dictName}}\',]]  del_flag = 0  where del_flag = 0 [[AND id = \'{{id}}\']] \", \"upDateFieldList\": [{\"label\": \"id(主键id)\", \"value\": \"id\", \"aliasName\": \"id\", \"isParamName\": true}, {\"label\": \"dict_label\", \"value\": \"dict_label\", \"aliasName\": \"dictLabel\", \"isParamName\": true}, {\"label\": \"dict_name\", \"value\": \"dict_name\", \"aliasName\": \"dictName\", \"isParamName\": true}, {\"label\": \"create_by(创建人)\", \"value\": \"create_by\", \"aliasName\": \"createBy\", \"isParamName\": true}, {\"label\": \"create_time(创建时间)\", \"value\": \"create_time\", \"aliasName\": \"createTime\", \"isParamName\": true}, {\"label\": \"update_by(更新人)\", \"value\": \"update_by\", \"aliasName\": \"updateBy\", \"isParamName\": true}, {\"label\": \"update_time(更新时间)\", \"value\": \"update_time\", \"aliasName\": \"updateTime\", \"isParamName\": true}, {\"label\": \"remarks(备注)\", \"value\": \"remarks\", \"aliasName\": \"remarks\", \"isParamName\": true}, {\"label\": \"del_flag(删除标识（0：未删除 1：已删除）)\", \"value\": \"del_flag\", \"aliasName\": \"delFlag\", \"isParamName\": true}], \"whereSelectList\": [{\"field\": \"id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"id\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}], \"updateCheckBoxList\": [\"dict_label\", \"dict_name\"]}}, {\"id\": 1755657166898, \"name\": \"deleteDict\", \"type\": \"SimpleSoftDelete\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"update <br/>&emsp;&emsp;data_dict <br/>set <br/>&emsp;&emsp;del_flag = 1 <br/>where <br/>&emsp;&emsp;del_flag = 0 <br/>&emsp;&emsp;[[AND id = \'{{id}}\']] <br/>\", \"actionType\": \"delete\", \"saveScript\": \"update data_dict set del_flag = 1 where del_flag = 0 [[AND id = \'{{id}}\']] \", \"physicsDelete\": false, \"whereSelectList\": [{\"field\": \"id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"id\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}, {\"id\": 1755657605542, \"name\": \"detailDict\", \"type\": \"SimpleQueryOne\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"select <br/>&emsp;&emsp;id as id,<br/>&emsp;&emsp;dict_label as dictLabel,<br/>&emsp;&emsp;dict_name as dictName,<br/>&emsp;&emsp;create_by as createBy,<br/>&emsp;&emsp;date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,<br/>&emsp;&emsp;update_by as updateBy,<br/>&emsp;&emsp;date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,<br/>&emsp;&emsp;remarks as remarks,<br/>&emsp;&emsp;del_flag as delFlag<br/> from <br/>&emsp;&emsp;data_dict\\n       <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>\\n       &emsp;&emsp;[[AND id = \'{{id}}\']] <br/><br/><br/>\", \"actionType\": \"selectOne\", \"saveScript\": \"select id as id,dict_label as dictLabel,dict_name as dictName,create_by as createBy,date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,update_by as updateBy,date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,remarks as remarks,del_flag as delFlag from data_dict\\n        where del_flag = 0 \\n       [[AND id = \'{{id}}\']] \", \"fieldSelected\": [{\"table\": \"data_dict\", \"fields\": [\"id\", \"dict_label\", \"dict_name\", \"create_by\", \"create_time\", \"update_by\", \"update_time\", \"remarks\", \"del_flag\"], \"isExpand\": false, \"isSelectAllField\": true, \"fieldAliasNameMapArray\": [{\"name\": \"id\", \"aliasName\": \"id\"}, {\"name\": \"dict_label\", \"aliasName\": \"dictLabel\"}, {\"name\": \"dict_name\", \"aliasName\": \"dictName\"}, {\"name\": \"create_by\", \"aliasName\": \"createBy\"}, {\"name\": \"create_time\", \"aliasName\": \"createTime\"}, {\"name\": \"update_by\", \"aliasName\": \"updateBy\"}, {\"name\": \"update_time\", \"aliasName\": \"updateTime\"}, {\"name\": \"remarks\", \"aliasName\": \"remarks\"}, {\"name\": \"del_flag\", \"aliasName\": \"delFlag\"}]}], \"pageParamName\": {\"pageNo\": \"page\", \"pageSize\": \"perPage\"}, \"orderSelectList\": [], \"whereSelectList\": [{\"field\": \"id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"id\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}]}', '3', 'DatadictModel', '2025-08-19 16:01:14', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 0, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('92116604e33846e690cbd3681aa3f460', '5d3fe37226644eac8b1abb4aa1ed28c2', '000000000000000000000000000000', '{\"field\": [{\"id\": 1756481100825, \"name\": \"id\", \"sort\": 0, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"主键id\", \"required\": true, \"aliasName\": \"id\", \"maxLength\": 36, \"primaryKey\": true}, {\"id\": 1756481100826, \"name\": \"create_by\", \"sort\": 1, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"创建人\", \"aliasName\": \"createBy\", \"maxLength\": 36, \"primaryKey\": false}, {\"id\": 1756481100827, \"name\": \"create_time\", \"sort\": 2, \"type\": \"datetime\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"创建时间\", \"aliasName\": \"createTime\", \"maxLength\": 0, \"primaryKey\": false, \"defaultValue\": \"CURRENT_TIMESTAMP\"}, {\"id\": 1756481100828, \"name\": \"update_by\", \"sort\": 3, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"更新人\", \"aliasName\": \"updateBy\", \"maxLength\": 36, \"primaryKey\": false}, {\"id\": 1756481100829, \"name\": \"update_time\", \"sort\": 4, \"type\": \"datetime\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"更新时间\", \"aliasName\": \"updateTime\", \"maxLength\": 0, \"primaryKey\": false, \"defaultValue\": \"CURRENT_TIMESTAMP\", \"updateByCurrentTime\": true}, {\"id\": 1756481100830, \"name\": \"remarks\", \"sort\": 5, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"备注\", \"aliasName\": \"remarks\", \"maxLength\": 255, \"primaryKey\": false}, {\"id\": 1756481100831, \"name\": \"del_flag\", \"sort\": 6, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"删除标识（0：未删除 1：已删除）\", \"aliasName\": \"delFlag\", \"maxLength\": 1, \"primaryKey\": false, \"defaultValue\": \"0\"}, {\"id\": 1756481109812, \"name\": \"name\", \"sort\": 7, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"required\": false, \"aliasName\": \"name\", \"maxLength\": 255, \"primaryKey\": false, \"defaultValue\": \"\", \"decimalDigits\": 2}, {\"id\": 1756481123105, \"name\": \"start_time\", \"sort\": 8, \"type\": \"datetime\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"required\": false, \"aliasName\": \"startTime\", \"maxLength\": 255, \"primaryKey\": false, \"defaultValue\": \"CURRENT_TIMESTAMP\", \"decimalDigits\": 2, \"updateByCurrentTime\": true}, {\"id\": 1756552261699, \"name\": \"field1756552261699\", \"sort\": 9, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"required\": false, \"aliasName\": \"FIELD1756552261699\", \"maxLength\": 255, \"primaryKey\": false, \"defaultValue\": \"\", \"decimalDigits\": 2}], \"table\": {\"name\": \"test\", \"engine\": \"InnoDB\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"aliasName\": \"\", \"rowFormat\": \"DYNAMIC\"}, \"action\": [{\"id\": 1756481172366, \"name\": \"add\", \"type\": \"SimpleInsert\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"insert into <br/>&emsp;&emsp;test ( id, create_by, update_by, remarks, name, start_time, field1756552261699 ) <br/>values <br/>&emsp;&emsp;( \'{{id}}\' , \'{{createBy}}\' , \'{{updateBy}}\' , \'{{remarks}}\' , \'{{name}}\' , \'{{startTime}}\' , \'{{FIELD1756552261699}}\' )\", \"actionType\": \"insert\", \"saveScript\": \"insert into test ( id, create_by, update_by, remarks, name, start_time, field1756552261699 ) values ( \'{{id}}\' , \'{{createBy}}\' , \'{{updateBy}}\' , \'{{remarks}}\' , \'{{name}}\' , \'{{startTime}}\' , \'{{FIELD1756552261699}}\' )\", \"insertFieldList\": [{\"label\": \"id(主键id)\", \"value\": \"id\", \"aliasName\": \"id\", \"isParamName\": true}, {\"label\": \"create_by(创建人)\", \"value\": \"create_by\", \"aliasName\": \"createBy\", \"isParamName\": true}, {\"label\": \"create_time(创建时间)\", \"value\": \"create_time\", \"aliasName\": \"createTime\", \"isParamName\": true}, {\"label\": \"update_by(更新人)\", \"value\": \"update_by\", \"aliasName\": \"updateBy\", \"isParamName\": true}, {\"label\": \"update_time(更新时间)\", \"value\": \"update_time\", \"aliasName\": \"updateTime\", \"isParamName\": true}, {\"label\": \"remarks(备注)\", \"value\": \"remarks\", \"aliasName\": \"remarks\", \"isParamName\": true}, {\"label\": \"del_flag(删除标识（0：未删除 1：已删除）)\", \"value\": \"del_flag\", \"aliasName\": \"delFlag\", \"isParamName\": true}, {\"label\": \"name\", \"value\": \"name\", \"aliasName\": \"name\", \"isParamName\": true}, {\"label\": \"start_time\", \"value\": \"start_time\", \"aliasName\": \"startTime\", \"isParamName\": true}, {\"label\": \"field1756552261699\", \"value\": \"field1756552261699\", \"aliasName\": \"FIELD1756552261699\", \"isParamName\": true}], \"whereSelectList\": [], \"allInsertCheckBox\": false, \"insertCheckBoxList\": [\"id\", \"create_by\", \"update_by\", \"remarks\", \"name\", \"start_time\", \"field1756552261699\"]}}, {\"id\": 1756481203063, \"name\": \"update\", \"type\": \"SimpleUpdate\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"update <br/>&emsp;&emsp;test <br/>set <br/>&emsp;&emsp;[[id = \'{{id}}\',]] <br/>&emsp;&emsp;[[create_by = \'{{createBy}}\',]] <br/>&emsp;&emsp;[[create_time = \'{{createTime}}\',]] <br/>&emsp;&emsp;[[update_by = \'{{updateBy}}\',]] <br/>&emsp;&emsp;[[update_time = \'{{updateTime}}\',]] <br/>&emsp;&emsp;[[remarks = \'{{remarks}}\',]] <br/>&emsp;&emsp;[[del_flag = \'{{delFlag}}\',]] <br/>&emsp;&emsp;[[name = \'{{name}}\',]] <br/>&emsp;&emsp;[[start_time = \'{{startTime}}\',]] <br/> &emsp;&emsp;del_flag = 0 <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>&emsp;&emsp;[[AND id = \'{{id}}\']] <br/>\", \"actionType\": \"update\", \"saveScript\": \"update test set [[id = \'{{id}}\',]] [[create_by = \'{{createBy}}\',]] [[create_time = \'{{createTime}}\',]] [[update_by = \'{{updateBy}}\',]] [[update_time = \'{{updateTime}}\',]] [[remarks = \'{{remarks}}\',]] [[del_flag = \'{{delFlag}}\',]] [[name = \'{{name}}\',]] [[start_time = \'{{startTime}}\',]]  del_flag = 0  where del_flag = 0 [[AND id = \'{{id}}\']] \", \"upDateFieldList\": [{\"label\": \"id(主键id)\", \"value\": \"id\", \"aliasName\": \"id\", \"isParamName\": true}, {\"label\": \"create_by(创建人)\", \"value\": \"create_by\", \"aliasName\": \"createBy\", \"isParamName\": true}, {\"label\": \"create_time(创建时间)\", \"value\": \"create_time\", \"aliasName\": \"createTime\", \"isParamName\": true}, {\"label\": \"update_by(更新人)\", \"value\": \"update_by\", \"aliasName\": \"updateBy\", \"isParamName\": true}, {\"label\": \"update_time(更新时间)\", \"value\": \"update_time\", \"aliasName\": \"updateTime\", \"isParamName\": true}, {\"label\": \"remarks(备注)\", \"value\": \"remarks\", \"aliasName\": \"remarks\", \"isParamName\": true}, {\"label\": \"del_flag(删除标识（0：未删除 1：已删除）)\", \"value\": \"del_flag\", \"aliasName\": \"delFlag\", \"isParamName\": true}, {\"label\": \"name\", \"value\": \"name\", \"aliasName\": \"name\", \"isParamName\": true}, {\"label\": \"start_time\", \"value\": \"start_time\", \"aliasName\": \"startTime\", \"isParamName\": true}], \"whereSelectList\": [{\"field\": \"id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"id\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}], \"updateCheckBoxList\": [\"id\", \"create_by\", \"create_time\", \"update_by\", \"update_time\", \"remarks\", \"del_flag\", \"name\", \"start_time\"]}}, {\"id\": 1756481223210, \"name\": \"searchOne\", \"type\": \"SimpleQueryOne\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"select <br/>&emsp;&emsp;id as id,<br/>&emsp;&emsp;create_by as createBy,<br/>&emsp;&emsp;date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,<br/>&emsp;&emsp;update_by as updateBy,<br/>&emsp;&emsp;date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,<br/>&emsp;&emsp;remarks as remarks,<br/>&emsp;&emsp;del_flag as delFlag,<br/>&emsp;&emsp;name as name,<br/>&emsp;&emsp;date_format(start_time,\'%Y-%m-%d %H:%i:%s\') as startTime<br/> from <br/>&emsp;&emsp;test\\n       <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>\\n       &emsp;&emsp;[[AND id = \'{{id}}\']] <br/>order by <br/>&emsp;&emsp;create_time DESC<br/>\", \"actionType\": \"selectOne\", \"saveScript\": \"select id as id,create_by as createBy,date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,update_by as updateBy,date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,remarks as remarks,del_flag as delFlag,name as name,date_format(start_time,\'%Y-%m-%d %H:%i:%s\') as startTime from test\\n        where del_flag = 0 \\n       [[AND id = \'{{id}}\']] order by create_time DESC\", \"fieldSelected\": [{\"table\": \"test\", \"fields\": [\"id\", \"create_by\", \"create_time\", \"update_by\", \"update_time\", \"remarks\", \"del_flag\", \"name\", \"start_time\"], \"isExpand\": false, \"isSelectAllField\": true, \"fieldAliasNameMapArray\": [{\"name\": \"id\", \"aliasName\": \"id\"}, {\"name\": \"create_by\", \"aliasName\": \"createBy\"}, {\"name\": \"create_time\", \"aliasName\": \"createTime\"}, {\"name\": \"update_by\", \"aliasName\": \"updateBy\"}, {\"name\": \"update_time\", \"aliasName\": \"updateTime\"}, {\"name\": \"remarks\", \"aliasName\": \"remarks\"}, {\"name\": \"del_flag\", \"aliasName\": \"delFlag\"}, {\"name\": \"name\", \"aliasName\": \"name\"}, {\"name\": \"start_time\", \"aliasName\": \"startTime\"}]}], \"pageParamName\": {\"pageNo\": \"page\", \"pageSize\": \"perPage\"}, \"orderSelectList\": [{\"field\": \"create_time\", \"orderType\": \"DESC\"}], \"whereSelectList\": [{\"field\": \"id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"id\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}, {\"id\": 1756481250944, \"name\": \"serachList\", \"type\": \"SimpleQuery\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"isPage\": false, \"rawScript\": \"select <br/>&emsp;&emsp;id as id,<br/>&emsp;&emsp;create_by as createBy,<br/>&emsp;&emsp;date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,<br/>&emsp;&emsp;update_by as updateBy,<br/>&emsp;&emsp;date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,<br/>&emsp;&emsp;remarks as remarks,<br/>&emsp;&emsp;del_flag as delFlag,<br/>&emsp;&emsp;name as name,<br/>&emsp;&emsp;date_format(start_time,\'%Y-%m-%d %H:%i:%s\') as startTime<br/> from <br/>&emsp;&emsp;test\\n       <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>\\n       &emsp;&emsp;[[AND name LIKE \'%{{name}}%\']] <br/>order by <br/>&emsp;&emsp;create_time DESC<br/>\", \"actionType\": \"select\", \"saveScript\": \"select id as id,create_by as createBy,date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,update_by as updateBy,date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,remarks as remarks,del_flag as delFlag,name as name,date_format(start_time,\'%Y-%m-%d %H:%i:%s\') as startTime from test\\n        where del_flag = 0 \\n       [[AND name LIKE \'%{{name}}%\']] order by create_time DESC\", \"fieldSelected\": [{\"table\": \"test\", \"fields\": [\"id\", \"create_by\", \"create_time\", \"update_by\", \"update_time\", \"remarks\", \"del_flag\", \"name\", \"start_time\"], \"isExpand\": false, \"isSelectAllField\": true, \"fieldAliasNameMapArray\": [{\"name\": \"id\", \"aliasName\": \"id\"}, {\"name\": \"create_by\", \"aliasName\": \"createBy\"}, {\"name\": \"create_time\", \"aliasName\": \"createTime\"}, {\"name\": \"update_by\", \"aliasName\": \"updateBy\"}, {\"name\": \"update_time\", \"aliasName\": \"updateTime\"}, {\"name\": \"remarks\", \"aliasName\": \"remarks\"}, {\"name\": \"del_flag\", \"aliasName\": \"delFlag\"}, {\"name\": \"name\", \"aliasName\": \"name\"}, {\"name\": \"start_time\", \"aliasName\": \"startTime\"}]}], \"pageParamName\": {\"pageNo\": \"page\", \"pageSize\": \"perPage\"}, \"orderSelectList\": [{\"field\": \"create_time\", \"orderType\": \"DESC\"}], \"whereSelectList\": [{\"field\": \"name\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"name\", \"valueB\": \"\", \"operator\": \"LIKE\", \"isParamName\": true}]}}, {\"id\": 1756481311713, \"name\": \"realDel\", \"type\": \"SimpleRealDelete\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"delete <br/>from <br/>&emsp;&emsp;test <br/>where <br/>&emsp;&emsp;del_flag = 0 <br/>&emsp;&emsp;[[AND id = \'{{id}}\']] <br/>\", \"actionType\": \"delete\", \"saveScript\": \"delete from test where del_flag = 0 [[AND id = \'{{id}}\']] \", \"physicsDelete\": true, \"whereSelectList\": [{\"field\": \"id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"id\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}, {\"id\": 1756481326713, \"name\": \"softDel\", \"type\": \"SimpleSoftDelete\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"update <br/>&emsp;&emsp;test <br/>set <br/>&emsp;&emsp;del_flag = 1 <br/>where <br/>&emsp;&emsp;del_flag = 0 <br/>&emsp;&emsp;[[AND id = \'{{id}}\']] <br/>\", \"actionType\": \"delete\", \"saveScript\": \"update test set del_flag = 1 where del_flag = 0 [[AND id = \'{{id}}\']] \", \"physicsDelete\": false, \"whereSelectList\": [{\"field\": \"id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"id\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}, {\"id\": 1756481353662, \"name\": \"groovy\", \"type\": \"CustomScript\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"\", \"actionType\": \"\", \"saveScript\": \"\"}}]}', '3', 'TestModel', '2025-08-29 23:25:00', '2025-08-30 19:11:17', '0', NULL, NULL, NULL, 0, NULL);
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('9495fa1527464c74a960b4cd79f646ac', 'f41197964a8a4305853b766532a4db0f', '000000000000000000000000000000', '{\"action\": \"delete\", \"modelName\": \"BusinessRoleModel\"}', '2', '/business-role/delete', '2025-08-19 10:48:00', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 4, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('989ae74869914daa94d9781e8d5fa493', '5d3fe37226644eac8b1abb4aa1ed28c2', '000000000000000000000000000000', '{\"action\": \"realDel\", \"modelName\": \"TestModel\"}', '2', '/test/realDel', '2025-08-29 23:32:09', '2025-08-29 23:32:33', '0', NULL, NULL, NULL, 6, NULL);
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('a167a3877961448f8dd782d1f1b9ae53', '5d3fe37226644eac8b1abb4aa1ed28c2', '000000000000000000000000000000', '{\"action\": \"add\", \"modelName\": \"TestModel\"}', '2', '/test/add', '2025-08-29 23:29:43', '2025-08-29 23:30:08', '0', NULL, NULL, NULL, 2, NULL);
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('a3ec5fc6b5904cbd90e49048237be14c', NULL, '000000000000000000000000000000', NULL, '1', '基础模块', '2025-08-19 14:41:59', '2025-08-29 23:32:28', '0', NULL, NULL, NULL, 0, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('a5214ce967d64843a71ee8e8068248b1', '2335c11cd9e24300b8c3d4b62e1fde9b', '000000000000000000000000000000', '{\"action\": \"addDictItem\", \"modelName\": \"DataDictItemModel\"}', '2', '/data-dict-item/add', '2025-08-20 00:03:04', '2025-08-29 23:29:55', '0', NULL, NULL, NULL, 4, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('a906a8d33e2e4f5294da872c7a9750a3', '13197a5cef7c49ef928f5065b5ce8dce', '000000000000000000000000000000', NULL, '1', '接口', '2025-08-20 09:29:50', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 0, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('acc82cca0a564588be879affd0600f4b', '55fea895f5d749d59b42f7ccc9a820b5', '000000000000000000000000000000', '{\"field\": [{\"id\": 1755619032034, \"name\": \"id\", \"sort\": 0, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"主键id\", \"required\": true, \"aliasName\": \"id\", \"maxLength\": 36, \"primaryKey\": true}, {\"id\": 1755619106002, \"name\": \"dict_name\", \"sort\": 1, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"required\": false, \"aliasName\": \"dictName\", \"maxLength\": 255, \"primaryKey\": false, \"defaultValue\": \"\"}, {\"id\": 1755619076571, \"name\": \"label\", \"sort\": 2, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"required\": false, \"aliasName\": \"label\", \"maxLength\": 255, \"primaryKey\": false, \"defaultValue\": \"\"}, {\"id\": 1755619097332, \"name\": \"value\", \"sort\": 3, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"required\": false, \"aliasName\": \"value\", \"maxLength\": 255, \"primaryKey\": false, \"defaultValue\": \"\"}, {\"id\": 1755619032035, \"name\": \"create_by\", \"sort\": 4, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"创建人\", \"aliasName\": \"createBy\", \"maxLength\": 36, \"primaryKey\": false}, {\"id\": 1755619032036, \"name\": \"create_time\", \"sort\": 5, \"type\": \"datetime\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"创建时间\", \"aliasName\": \"createTime\", \"maxLength\": 0, \"primaryKey\": false, \"defaultValue\": \"CURRENT_TIMESTAMP\"}, {\"id\": 1755619032037, \"name\": \"update_by\", \"sort\": 6, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"更新人\", \"aliasName\": \"updateBy\", \"maxLength\": 36, \"primaryKey\": false}, {\"id\": 1755619032038, \"name\": \"update_time\", \"sort\": 7, \"type\": \"datetime\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"更新时间\", \"aliasName\": \"updateTime\", \"maxLength\": 0, \"primaryKey\": false, \"defaultValue\": \"CURRENT_TIMESTAMP\", \"updateByCurrentTime\": true}, {\"id\": 1755619032039, \"name\": \"remarks\", \"sort\": 8, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"备注\", \"aliasName\": \"remarks\", \"maxLength\": 255, \"primaryKey\": false}, {\"id\": 1755619032040, \"name\": \"del_flag\", \"sort\": 9, \"type\": \"varchar\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"删除标识（0：未删除 1：已删除）\", \"aliasName\": \"delFlag\", \"maxLength\": 1, \"primaryKey\": false, \"defaultValue\": \"0\"}], \"table\": {\"name\": \"data_dict_item\", \"engine\": \"InnoDB\", \"charset\": \"utf8mb4\", \"collate\": \"utf8mb4_0900_ai_ci\", \"comment\": \"\", \"aliasName\": \"\", \"rowFormat\": \"DYNAMIC\"}, \"action\": [{\"id\": 1755619162088, \"name\": \"addDictItem\", \"type\": \"SimpleInsert\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"insert into <br/>&emsp;&emsp;data_dict_item ( id, dict_name, label, value, del_flag ) <br/>values <br/>&emsp;&emsp;( \'{{id}}\' , \'{{dictName}}\' , \'{{label}}\' , \'{{value}}\' , \'0\' )\", \"actionType\": \"insert\", \"saveScript\": \"insert into data_dict_item ( id, dict_name, label, value, del_flag ) values ( \'{{id}}\' , \'{{dictName}}\' , \'{{label}}\' , \'{{value}}\' , \'0\' )\", \"insertFieldList\": [{\"label\": \"id(主键id)\", \"value\": \"id\", \"aliasName\": \"id\", \"isParamName\": true}, {\"label\": \"dict_name\", \"value\": \"dict_name\", \"aliasName\": \"dictName\", \"isParamName\": true}, {\"label\": \"label\", \"value\": \"label\", \"aliasName\": \"label\", \"isParamName\": true}, {\"label\": \"value\", \"value\": \"value\", \"aliasName\": \"value\", \"isParamName\": true}, {\"label\": \"create_by(创建人)\", \"value\": \"create_by\", \"aliasName\": \"createBy\", \"isParamName\": true}, {\"label\": \"create_time(创建时间)\", \"value\": \"create_time\", \"aliasName\": \"createTime\", \"isParamName\": true}, {\"label\": \"update_by(更新人)\", \"value\": \"update_by\", \"aliasName\": \"updateBy\", \"isParamName\": true}, {\"label\": \"update_time(更新时间)\", \"value\": \"update_time\", \"aliasName\": \"updateTime\", \"isParamName\": true}, {\"label\": \"remarks(备注)\", \"value\": \"remarks\", \"aliasName\": \"remarks\", \"isParamName\": true}, {\"label\": \"del_flag(删除标识（0：未删除 1：已删除）)\", \"value\": \"del_flag\", \"aliasName\": \"0\", \"isParamName\": false}], \"whereSelectList\": [], \"allInsertCheckBox\": false, \"insertCheckBoxList\": [\"id\", \"dict_name\", \"label\", \"value\", \"del_flag\"]}}, {\"id\": 1755619193244, \"name\": \"queryDictItemsByDictName\", \"type\": \"SimpleQuery\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"isPage\": false, \"rawScript\": \"select <br/>&emsp;&emsp;id as id,<br/>&emsp;&emsp;dict_name as dictName,<br/>&emsp;&emsp;label as label,<br/>&emsp;&emsp;value as value,<br/>&emsp;&emsp;create_by as createBy,<br/>&emsp;&emsp;date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,<br/>&emsp;&emsp;update_by as updateBy,<br/>&emsp;&emsp;date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,<br/>&emsp;&emsp;remarks as remarks,<br/>&emsp;&emsp;del_flag as delFlag<br/> from <br/>&emsp;&emsp;data_dict_item\\n       <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>\\n       &emsp;&emsp;[[AND dict_name = \'{{dictName}}\']] <br/><br/><br/>\", \"actionType\": \"select\", \"saveScript\": \"select id as id,dict_name as dictName,label as label,value as value,create_by as createBy,date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,update_by as updateBy,date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,remarks as remarks,del_flag as delFlag from data_dict_item\\n        where del_flag = 0 \\n       [[AND dict_name = \'{{dictName}}\']] \", \"fieldSelected\": [{\"table\": \"data_dict_item\", \"fields\": [\"id\", \"dict_name\", \"label\", \"value\", \"create_by\", \"create_time\", \"update_by\", \"update_time\", \"remarks\", \"del_flag\"], \"isExpand\": false, \"isSelectAllField\": true, \"fieldAliasNameMapArray\": [{\"name\": \"id\", \"aliasName\": \"id\"}, {\"name\": \"dict_name\", \"aliasName\": \"dictName\"}, {\"name\": \"label\", \"aliasName\": \"label\"}, {\"name\": \"value\", \"aliasName\": \"value\"}, {\"name\": \"create_by\", \"aliasName\": \"createBy\"}, {\"name\": \"create_time\", \"aliasName\": \"createTime\"}, {\"name\": \"update_by\", \"aliasName\": \"updateBy\"}, {\"name\": \"update_time\", \"aliasName\": \"updateTime\"}, {\"name\": \"remarks\", \"aliasName\": \"remarks\"}, {\"name\": \"del_flag\", \"aliasName\": \"delFlag\"}]}], \"pageParamName\": {\"pageNo\": \"page\", \"pageSize\": \"perPage\"}, \"orderSelectList\": [], \"whereSelectList\": [{\"field\": \"dict_name\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"dictName\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}, {\"id\": 1755658223504, \"name\": \"editDictItem\", \"type\": \"SimpleUpdate\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"update <br/>&emsp;&emsp;data_dict_item <br/>set <br/>&emsp;&emsp;[[label = \'{{label}}\',]] <br/>&emsp;&emsp;[[value = \'{{value}}\',]] <br/> &emsp;&emsp;del_flag = 0 <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>&emsp;&emsp;[[AND id = \'{{id}}\']] <br/>\", \"actionType\": \"update\", \"saveScript\": \"update data_dict_item set [[label = \'{{label}}\',]] [[value = \'{{value}}\',]]  del_flag = 0  where del_flag = 0 [[AND id = \'{{id}}\']] \", \"upDateFieldList\": [{\"label\": \"id(主键id)\", \"value\": \"id\", \"aliasName\": \"id\", \"isParamName\": true}, {\"label\": \"dict_name\", \"value\": \"dict_name\", \"aliasName\": \"dictName\", \"isParamName\": true}, {\"label\": \"label\", \"value\": \"label\", \"aliasName\": \"label\", \"isParamName\": true}, {\"label\": \"value\", \"value\": \"value\", \"aliasName\": \"value\", \"isParamName\": true}, {\"label\": \"create_by(创建人)\", \"value\": \"create_by\", \"aliasName\": \"createBy\", \"isParamName\": true}, {\"label\": \"create_time(创建时间)\", \"value\": \"create_time\", \"aliasName\": \"createTime\", \"isParamName\": true}, {\"label\": \"update_by(更新人)\", \"value\": \"update_by\", \"aliasName\": \"updateBy\", \"isParamName\": true}, {\"label\": \"update_time(更新时间)\", \"value\": \"update_time\", \"aliasName\": \"updateTime\", \"isParamName\": true}, {\"label\": \"remarks(备注)\", \"value\": \"remarks\", \"aliasName\": \"remarks\", \"isParamName\": true}, {\"label\": \"del_flag(删除标识（0：未删除 1：已删除）)\", \"value\": \"del_flag\", \"aliasName\": \"delFlag\", \"isParamName\": true}], \"whereSelectList\": [{\"field\": \"id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"id\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}], \"updateCheckBoxList\": [\"label\", \"value\"]}}, {\"id\": 1755658259571, \"name\": \"deleteDictItem\", \"type\": \"SimpleSoftDelete\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"rawScript\": \"update <br/>&emsp;&emsp;data_dict_item <br/>set <br/>&emsp;&emsp;del_flag = 1 <br/>where <br/>&emsp;&emsp;del_flag = 0 <br/>&emsp;&emsp;[[AND id = \'{{id}}\']] <br/>\", \"actionType\": \"delete\", \"saveScript\": \"update data_dict_item set del_flag = 1 where del_flag = 0 [[AND id = \'{{id}}\']] \", \"physicsDelete\": false, \"whereSelectList\": [{\"field\": \"id\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"id\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}, {\"id\": 1755927006990, \"name\": \"getByDictName\", \"type\": \"SimpleQuery\", \"after\": \"\", \"label\": \"\", \"shell\": \"\", \"before\": \"\", \"detail\": {\"isPage\": false, \"rawScript\": \"select <br/>&emsp;&emsp;id as id,<br/>&emsp;&emsp;dict_name as dictName,<br/>&emsp;&emsp;label as label,<br/>&emsp;&emsp;value as value,<br/>&emsp;&emsp;create_by as createBy,<br/>&emsp;&emsp;date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,<br/>&emsp;&emsp;update_by as updateBy,<br/>&emsp;&emsp;date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,<br/>&emsp;&emsp;remarks as remarks,<br/>&emsp;&emsp;del_flag as delFlag<br/> from <br/>&emsp;&emsp;data_dict_item\\n       <br/> where <br/>&emsp;&emsp;del_flag = 0 <br/>\\n       &emsp;&emsp;[[AND dict_name = \'{{dictName}}\']] <br/>order by <br/>&emsp;&emsp;create_time DESC<br/>\", \"actionType\": \"select\", \"saveScript\": \"select id as id,dict_name as dictName,label as label,value as value,create_by as createBy,date_format(create_time,\'%Y-%m-%d %H:%i:%s\') as createTime,update_by as updateBy,date_format(update_time,\'%Y-%m-%d %H:%i:%s\') as updateTime,remarks as remarks,del_flag as delFlag from data_dict_item\\n        where del_flag = 0 \\n       [[AND dict_name = \'{{dictName}}\']] order by create_time DESC\", \"fieldSelected\": [{\"table\": \"data_dict_item\", \"fields\": [\"id\", \"dict_name\", \"label\", \"value\", \"create_by\", \"create_time\", \"update_by\", \"update_time\", \"remarks\", \"del_flag\"], \"isExpand\": false, \"isSelectAllField\": true, \"fieldAliasNameMapArray\": [{\"name\": \"id\", \"aliasName\": \"id\"}, {\"name\": \"dict_name\", \"aliasName\": \"dictName\"}, {\"name\": \"label\", \"aliasName\": \"label\"}, {\"name\": \"value\", \"aliasName\": \"value\"}, {\"name\": \"create_by\", \"aliasName\": \"createBy\"}, {\"name\": \"create_time\", \"aliasName\": \"createTime\"}, {\"name\": \"update_by\", \"aliasName\": \"updateBy\"}, {\"name\": \"update_time\", \"aliasName\": \"updateTime\"}, {\"name\": \"remarks\", \"aliasName\": \"remarks\"}, {\"name\": \"del_flag\", \"aliasName\": \"delFlag\"}]}], \"pageParamName\": {\"pageNo\": \"page\", \"pageSize\": \"perPage\"}, \"orderSelectList\": [{\"field\": \"create_time\", \"orderType\": \"DESC\"}], \"whereSelectList\": [{\"field\": \"dict_name\", \"logic\": \"AND\", \"order\": 0, \"valueA\": \"dictName\", \"valueB\": \"\", \"operator\": \"=\", \"isParamName\": true}]}}]}', '3', 'DataDictItemModel', '2025-08-19 23:57:12', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 0, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('b00a8e8268524c3eb4eeab9aee035dc1', 'a3ec5fc6b5904cbd90e49048237be14c', '000000000000000000000000000000', NULL, '1', '角色管理', '2025-08-19 14:42:10', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 0, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('b0b0af38098d448fa858fdc008659e88', '5d3fe37226644eac8b1abb4aa1ed28c2', '000000000000000000000000000000', '{\"action\": \"searchOne\", \"modelName\": \"TestModel\"}', '2', '/test/searchOne', '2025-08-29 23:30:19', '2025-08-29 23:30:22', '0', NULL, NULL, NULL, 3, NULL);
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('b249382e2b43417ba6f3a0302a12b922', 'a906a8d33e2e4f5294da872c7a9750a3', '000000000000000000000000000000', '{\"action\": \"editDict\", \"modelName\": \"DatadictModel\"}', '2', '/data-dict/edit', '2025-08-20 10:28:44', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 2, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('b50ff8b82ccc4163953e81bcaf78fb1c', 'a3ec5fc6b5904cbd90e49048237be14c', '000000000000000000000000000000', NULL, '1', '用户管理', '2025-08-13 11:33:24', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 1, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('b5201c6139184de38f08391d6ba89064', 'a906a8d33e2e4f5294da872c7a9750a3', '000000000000000000000000000000', '{\"action\": \"deleteDict\", \"modelName\": \"DatadictModel\"}', '2', '/data-dict/delete', '2025-08-20 10:38:23', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 1, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('be9359e2e0cc44978cf409ba32751329', 'b50ff8b82ccc4163953e81bcaf78fb1c', '000000000000000000000000000000', NULL, '1', '模型', '2025-08-13 11:33:31', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 1, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('bf72766dc38d47ff920b2aa27d6c39c9', '5d3fe37226644eac8b1abb4aa1ed28c2', '000000000000000000000000000000', '{\"action\": \"softDel\", \"modelName\": \"TestModel\"}', '2', '/test/softDel', '2025-08-29 23:32:24', '2025-08-29 23:32:30', '0', NULL, NULL, NULL, 5, NULL);
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('c84bf3c76f7945acb42324703b0f182b', '13197a5cef7c49ef928f5065b5ce8dce', '000000000000000000000000000000', NULL, '1', '模型', '2025-08-20 09:30:06', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 1, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('ce500af725d8479da7e64a11351f5c41', '5d3fe37226644eac8b1abb4aa1ed28c2', '000000000000000000000000000000', '{\"action\": \"serachList\", \"modelName\": \"TestModel\"}', '2', '/test/searchList', '2025-08-29 23:30:40', '2025-08-29 23:30:46', '0', NULL, NULL, NULL, 4, NULL);
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('e0990b42026242b18326e6886929bf4c', 'f41197964a8a4305853b766532a4db0f', '000000000000000000000000000000', '{\"action\": \"list\", \"modelName\": \"BusinessRoleModel\"}', '2', '/business-role/list', '2025-08-14 09:18:02', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 1, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('e4794581f87b4367a23b4a4a6c02df89', '2335c11cd9e24300b8c3d4b62e1fde9b', '000000000000000000000000000000', '{\"action\": \"deleteDictItem\", \"modelName\": \"DataDictItemModel\"}', '2', '/data-dict-item/delete', '2025-08-20 10:52:04', '2025-08-29 23:29:55', '0', NULL, NULL, NULL, 3, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('e78ada68774a48a2b2a5b0b6669e74d1', '2335c11cd9e24300b8c3d4b62e1fde9b', '000000000000000000000000000000', '{\"action\": \"queryDictItemsByDictName\", \"modelName\": \"DataDictItemModel\"}', '2', '/data-dict-item/querDictItemsByDictName', '2025-08-20 00:02:12', '2025-08-29 23:29:55', '0', NULL, NULL, NULL, 2, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('f162486e13fc46c08e1fe95ce88e279f', '13197a5cef7c49ef928f5065b5ce8dce', '000000000000000000000000000000', NULL, '1', '字典项', '2025-08-19 23:56:51', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 2, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('f41197964a8a4305853b766532a4db0f', 'b00a8e8268524c3eb4eeab9aee035dc1', '000000000000000000000000000000', NULL, '1', '接口', '2025-08-19 14:48:17', '2025-08-28 20:01:50', '0', NULL, NULL, NULL, 0, '{}');
INSERT INTO `system_application_service` (`id`, `parent_id`, `app_id`, `data`, `type`, `name`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('f4efa122e40948a087f51a93608599d9', '2335c11cd9e24300b8c3d4b62e1fde9b', '000000000000000000000000000000', '{\"action\": \"editDictItem\", \"modelName\": \"DataDictItemModel\"}', '2', '/data-dict-item/edit', '2025-08-20 10:51:43', '2025-08-29 23:29:55', '0', NULL, NULL, NULL, 1, '{}');
COMMIT;

-- ----------------------------
-- Table structure for system_application_web
-- ----------------------------
DROP TABLE IF EXISTS `system_application_web`;
CREATE TABLE `system_application_web` (
                                          `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
                                          `parent_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '父级id',
                                          `app_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '应用id',
                                          `data` json DEFAULT NULL COMMENT '页面资源',
                                          `type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '页面类型（1:文件夹 2:页面 3:自定义菜单）',
                                          `label` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '菜单名称(中文)',
                                          `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '菜单名称（英文）',
                                          `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '菜单图标',
                                          `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                          `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                          `del_flag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '删除标识（0:未删除 1:已删除）',
                                          `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                          `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                          `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                                          `sort` int DEFAULT '0' COMMENT '排序',
                                          `extra` json DEFAULT NULL,
                                          PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of system_application_web
-- ----------------------------
BEGIN;
INSERT INTO `system_application_web` (`id`, `parent_id`, `app_id`, `data`, `type`, `label`, `code`, `icon`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('369ef6aa57da4307b0b685edf50fd564', '969e416f9e03421a8d78b381fd3f7247', '000000000000000000000000000000', '{\"id\": \"u:565b28a8b24c\", \"body\": [{\"id\": \"u:944f42a6fa11\", \"api\": {\"url\": \"/business-role/list\", \"method\": \"get\"}, \"mode\": \"table2\", \"type\": \"crud2\", \"dsType\": \"api\", \"filter\": {\"id\": \"u:9587ed65c0ba\", \"body\": [{\"id\": \"u:78cda740c1a2\", \"name\": \"name\", \"size\": \"full\", \"type\": \"input-text\", \"label\": \"名称\", \"placeholder\": \"请输入角色名称\"}], \"feat\": \"Insert\", \"mode\": \"inline\", \"type\": \"form\", \"title\": \"条件查询\", \"actions\": [{\"id\": \"u:bd04c06e8c2f\", \"type\": \"reset\", \"label\": \"重置\"}, {\"id\": \"u:922391543add\", \"type\": \"submit\", \"label\": \"查询\", \"level\": \"primary\"}], \"behavior\": [\"SimpleQuery\"], \"columnCount\": 3, \"clearValueOnHidden\": true}, \"columns\": [{\"id\": \"u:ae4c5d084f00\", \"name\": \"name\", \"type\": \"tpl\", \"align\": \"center\", \"title\": \"名称\", \"placeholder\": \"-\"}, {\"id\": \"u:03049f077f1a\", \"type\": \"operation\", \"title\": \"操作\", \"buttons\": [{\"id\": \"u:f4051d37729c\", \"type\": \"button\", \"label\": \"查看\", \"level\": \"link\", \"onEvent\": {\"click\": {\"actions\": [{\"dialog\": {\"id\": \"u:6168289fb9f8\", \"body\": [{\"id\": \"u:174fcd067259\", \"body\": [{\"id\": \"u:211361fa90f3\", \"row\": 0, \"name\": \"name\", \"type\": \"input-text\", \"label\": \"名称\", \"disabled\": false, \"readOnly\": true}], \"feat\": \"Edit\", \"mode\": \"flex\", \"type\": \"form\", \"title\": \"编辑数据\", \"dsType\": \"api\", \"actions\": [{\"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"type\": \"button\", \"label\": \"提交\", \"level\": \"primary\", \"actionType\": \"submit\"}], \"onEvent\": {\"submitSucc\": {\"actions\": [{\"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:944f42a6fa11\"}]}}, \"labelAlign\": \"top\", \"resetAfterSubmit\": true}], \"size\": \"md\", \"type\": \"dialog\", \"title\": \"查看数据\", \"actions\": [{\"id\": \"u:89f1a7a55999\", \"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}], \"draggable\": false, \"actionType\": \"dialog\", \"closeOnEsc\": false, \"showLoading\": true, \"showErrorMsg\": true, \"closeOnOutside\": false, \"showCloseButton\": true}, \"actionType\": \"dialog\"}]}}, \"behavior\": \"Edit\"}, {\"id\": \"u:7c6258a6d51c\", \"type\": \"button\", \"label\": \"编辑\", \"level\": \"link\", \"onEvent\": {\"click\": {\"actions\": [{\"dialog\": {\"id\": \"u:1e8a73cd3b44\", \"body\": [{\"id\": \"u:62e8544d3a8f\", \"body\": [], \"feat\": \"View\", \"mode\": \"flex\", \"type\": \"form\", \"title\": \"查看数据\", \"dsType\": \"api\", \"static\": true, \"actions\": [{\"type\": \"button\", \"label\": \"关闭\", \"actionType\": \"cancel\"}], \"onEvent\": {\"submitSucc\": {\"actions\": [{\"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:944f42a6fa11\"}]}}, \"labelAlign\": \"top\"}, {\"id\": \"u:e88d3e2a443f\", \"name\": \"name\", \"type\": \"input-text\", \"label\": \"名称\", \"required\": true, \"maxLength\": 32, \"validations\": {\"maxLength\": 32}, \"validateOnChange\": false}], \"size\": \"md\", \"type\": \"dialog\", \"title\": \"编辑数据\", \"actions\": [{\"id\": \"u:eca68640e575\", \"type\": \"button\", \"label\": \"关闭\", \"actionType\": \"cancel\"}, {\"id\": \"u:fecfa0740588\", \"type\": \"button\", \"label\": \"确认\", \"level\": \"primary\", \"onEvent\": {\"click\": {\"weight\": 0, \"actions\": [{\"outputVar\": \"result\", \"actionType\": \"validate\", \"componentId\": \"u:62e8544d3a8f\"}, {\"api\": {\"url\": \"/business-role/edit\", \"data\": {\"&\": \"$$\"}, \"method\": \"post\", \"adaptor\": \"\", \"dataType\": \"json\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"options\": {}, \"outputVar\": \"responseResult\", \"actionType\": \"ajax\", \"ignoreError\": false, \"stopPropagation\": \"${IF(event.data.result.error != \'\',true,false)}\"}]}}, \"actionType\": \"cancel\"}], \"draggable\": false, \"actionType\": \"dialog\", \"closeOnEsc\": false, \"showLoading\": true, \"showErrorMsg\": true, \"closeOnOutside\": false, \"showCloseButton\": true}, \"actionType\": \"dialog\"}]}}, \"behavior\": \"View\"}, {\"id\": \"u:e03c37f2d4e7\", \"type\": \"button\", \"label\": \"删除\", \"level\": \"link\", \"onEvent\": {\"click\": {\"actions\": [{\"api\": {\"url\": \"/business-role/delete\", \"data\": {\"id\": \"${id}\"}, \"method\": \"post\", \"adaptor\": \"\", \"dataType\": \"json\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"options\": {}, \"outputVar\": \"responseResult\", \"actionType\": \"ajax\"}, {\"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:944f42a6fa11\"}]}}, \"behavior\": \"Delete\", \"themeCss\": {\"className\": {\"font:default\": {\"color\": \"#ef1a0b\"}}}, \"className\": \"m-r-xs text-danger\", \"confirmText\": \"确认要删除数据\"}, {\"id\": \"u:49697df25d04\", \"label\": \"资源配置\", \"level\": \"link\", \"onEvent\": {\"click\": {\"weight\": 0, \"actions\": [{\"dialog\": {\"$ref\": \"modal-ref-1\"}, \"actionType\": \"dialog\", \"ignoreError\": true}]}}}]}], \"loadType\": \"pagination\", \"showHeader\": true, \"primaryField\": \"id\", \"syncLocation\": true, \"editorSetting\": {\"mock\": {\"enable\": true, \"maxDisplayRows\": 5}}, \"footerToolbar\": [{\"id\": \"u:611394153358\", \"type\": \"flex\", \"items\": [{\"id\": \"u:ae94fc0b3e0f\", \"body\": [], \"type\": \"container\", \"align\": \"left\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"flexBasis\": \"auto\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-start\"}, \"wrapperBody\": false}, {\"id\": \"u:2646e3c0a158\", \"body\": [{\"id\": \"u:41cc61988c19\", \"type\": \"pagination\", \"align\": \"right\", \"layout\": [\"total\", \"perPage\", \"pager\"], \"perPage\": 10, \"behavior\": \"Pagination\", \"perPageAvailable\": [10, 20, 50, 100]}], \"type\": \"container\", \"align\": \"right\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"flexBasis\": \"auto\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-end\"}, \"wrapperBody\": false}], \"style\": {\"position\": \"static\"}, \"justify\": \"flex-start\", \"direction\": \"row\", \"alignItems\": \"stretch\"}], \"headerToolbar\": [{\"id\": \"u:31327a5a5d68\", \"type\": \"flex\", \"items\": [{\"id\": \"u:a73222820896\", \"body\": [{\"id\": \"u:2f290c5a760b\", \"type\": \"button\", \"label\": \"新增\", \"level\": \"primary\", \"onEvent\": {\"click\": {\"actions\": [{\"dialog\": {\"id\": \"u:13c89365b9ec\", \"body\": [{\"id\": \"u:d0abe4bf9e71\", \"body\": [{\"id\": \"u:6dcc705240a0\", \"row\": 0, \"name\": \"name\", \"type\": \"input-text\", \"label\": \"名称\", \"required\": true, \"maxLength\": 32, \"validations\": {\"maxLength\": 32}, \"validateOnChange\": false}], \"feat\": \"Insert\", \"mode\": \"flex\", \"type\": \"form\", \"title\": \"新增数据\", \"dsType\": \"api\", \"actions\": [{\"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"type\": \"button\", \"label\": \"提交\", \"level\": \"primary\", \"actionType\": \"submit\"}], \"onEvent\": {\"submitSucc\": {\"actions\": [{\"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:944f42a6fa11\"}]}}, \"labelAlign\": \"top\", \"resetAfterSubmit\": true}], \"size\": \"md\", \"type\": \"dialog\", \"title\": \"新增数据\", \"actions\": [{\"id\": \"u:14b7ab30fa94\", \"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"id\": \"u:519faa1c8a18\", \"type\": \"button\", \"label\": \"提交\", \"level\": \"primary\", \"onEvent\": {\"click\": {\"weight\": 0, \"actions\": [{\"args\": {}, \"outputVar\": \"result\", \"actionType\": \"validate\", \"componentId\": \"u:d0abe4bf9e71\"}, {\"api\": {\"url\": \"/business-role/add\", \"data\": {\"&\": \"${event.data.result.payload}\"}, \"method\": \"post\", \"adaptor\": \"\", \"dataType\": \"json\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"options\": {}, \"outputVar\": \"responseResult\", \"actionType\": \"ajax\", \"ignoreError\": false}]}}, \"actionType\": \"submit\"}], \"draggable\": false, \"actionType\": \"dialog\", \"closeOnEsc\": false, \"showLoading\": true, \"showErrorMsg\": true, \"closeOnOutside\": false, \"showCloseButton\": true}, \"actionType\": \"dialog\"}]}}, \"behavior\": \"Insert\", \"className\": \"m-r-xs\"}], \"type\": \"container\", \"align\": \"left\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"flexBasis\": \"auto\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-start\"}, \"behavior\": [\"Insert\", \"BulkEdit\", \"BulkDelete\"], \"wrapperBody\": false}, {\"id\": \"u:819dc95dda6e\", \"body\": [], \"type\": \"container\", \"align\": \"right\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"flexBasis\": \"auto\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-end\"}, \"behavior\": [\"FuzzyQuery\"], \"wrapperBody\": false}], \"style\": {\"position\": \"static\"}, \"justify\": \"flex-start\", \"direction\": \"row\", \"alignItems\": \"stretch\"}]}], \"definitions\": {\"modal-ref-1\": {\"id\": \"u:70fb3c07c960\", \"body\": [{\"id\": \"u:cd73fd00e8a2\", \"name\": \"resourceList\", \"type\": \"transfer\", \"label\": \"\", \"source\": {\"url\": \"/v1/system-application-web/list\", \"method\": \"get\", \"adaptor\": \"\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"onEvent\": {\"selectAll\": {\"weight\": 0, \"actions\": []}}, \"disabled\": false, \"sortable\": true, \"labelField\": \"label\", \"searchable\": true, \"selectMode\": \"tree\", \"statistics\": false, \"valueField\": \"id\", \"description\": \"\", \"resultSearchable\": true, \"resultListModeFollowSelect\": false}], \"type\": \"dialog\", \"$$ref\": \"modal-ref-1\", \"title\": \"资源配置\", \"actions\": [{\"id\": \"u:1e26b5640c71\", \"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"id\": \"u:93c262330600\", \"type\": \"button\", \"label\": \"确定\", \"onEvent\": {\"click\": {\"weight\": 0, \"actions\": [{\"api\": {\"url\": \"/business-role-resource/add\", \"data\": {\"roleId\": \"${id}\", \"resourceList\": \"${resourceList}\"}, \"method\": \"post\", \"adaptor\": \"\", \"dataType\": \"json\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"options\": {}, \"outputVar\": \"responseResult\", \"actionType\": \"ajax\", \"ignoreError\": false}, {\"args\": {}, \"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:944f42a6fa11\"}]}}, \"primary\": true, \"actionType\": \"confirm\"}], \"draggable\": false, \"closeOnEsc\": false, \"showLoading\": true, \"showErrorMsg\": true, \"closeOnOutside\": false, \"showCloseButton\": true}}, \"pullRefresh\": {\"disabled\": true}, \"asideResizor\": false}', '2', '角色管理', 'role-management', 'Avatar', '2025-08-18 14:48:45', '2025-08-28 20:03:12', '0', NULL, NULL, NULL, 0, '{\"webShowFlag\": 1}');
INSERT INTO `system_application_web` (`id`, `parent_id`, `app_id`, `data`, `type`, `label`, `code`, `icon`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('969e416f9e03421a8d78b381fd3f7247', NULL, '000000000000000000000000000000', NULL, '1', '基础模块', 'base-model-management', 'Folder', '2025-08-18 11:28:29', '2025-08-28 20:03:12', '0', NULL, NULL, NULL, 0, '{\"webShowFlag\": 1}');
INSERT INTO `system_application_web` (`id`, `parent_id`, `app_id`, `data`, `type`, `label`, `code`, `icon`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('a26b887d85da4f83b1ebcf363320caef', '969e416f9e03421a8d78b381fd3f7247', '000000000000000000000000000000', '{\"id\": \"u:ae4a85272d4b\", \"body\": [{\"id\": \"u:77ac0e9b5953\", \"api\": {\"url\": \"/data-dict/query\", \"method\": \"get\", \"adaptor\": \"\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"mode\": \"table2\", \"type\": \"crud2\", \"dsType\": \"api\", \"filter\": {\"id\": \"u:599d3e513217\", \"body\": [{\"id\": \"u:b8ea7ac36239\", \"name\": \"dictLabel\", \"size\": \"full\", \"type\": \"input-text\", \"label\": \"字典标签\", \"behavior\": \"SimpleQuery\", \"required\": false, \"placeholder\": \"字典中文名\"}, {\"id\": \"u:61779fbc263a\", \"name\": \"dictName\", \"size\": \"full\", \"type\": \"input-text\", \"label\": \"字典名称\", \"behavior\": \"SimpleQuery\", \"required\": false, \"placeholder\": \"字典英文名\"}], \"feat\": \"Insert\", \"mode\": \"inline\", \"type\": \"form\", \"title\": \"条件查询\", \"actions\": [{\"id\": \"u:9503c66eecf4\", \"type\": \"reset\", \"label\": \"重置\"}, {\"id\": \"u:cdf7f9cc8b76\", \"type\": \"submit\", \"label\": \"查询\", \"level\": \"primary\"}], \"behavior\": [\"SimpleQuery\"], \"columnCount\": 3, \"wrapWithPanel\": true, \"clearValueOnHidden\": true}, \"columns\": [{\"id\": \"u:b2d0ae289235\", \"name\": \"dictLabel\", \"type\": \"tpl\", \"title\": \"字典标签\"}, {\"id\": \"u:21ca998cd829\", \"name\": \"dictName\", \"type\": \"tpl\", \"title\": \"字典名称\"}, {\"id\": \"u:b537f5fbdacc\", \"type\": \"operation\", \"title\": \"操作\", \"buttons\": [{\"id\": \"u:cf4dc62d9691\", \"type\": \"button\", \"label\": \"编辑\", \"level\": \"link\", \"onEvent\": {\"click\": {\"actions\": [{\"dialog\": {\"id\": \"u:efe968b95d7b\", \"body\": [{\"id\": \"u:136de7799fef\", \"api\": {\"url\": \"/data-dict/edit\", \"data\": {\"id\": \"${id}\", \"dictName\": \"${dictName}\", \"dictLabel\": \"${dictLabel}\"}, \"method\": \"post\", \"adaptor\": \"\", \"dataType\": \"json\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"body\": [{\"id\": \"u:3876d6b35023\", \"row\": 0, \"name\": \"dictLabel\", \"type\": \"input-text\", \"label\": \"字典标签\", \"required\": true, \"placeholder\": \"字典中文名\"}, {\"id\": \"u:1933c9ea9f08\", \"row\": 1, \"name\": \"dictName\", \"type\": \"input-text\", \"label\": \"字典名称（不可编辑）\", \"readOnly\": true, \"required\": true, \"placeholder\": \"字典英文名\"}], \"feat\": \"Edit\", \"mode\": \"flex\", \"type\": \"form\", \"title\": \"编辑数据\", \"dsType\": \"api\", \"actions\": [{\"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"type\": \"button\", \"label\": \"提交\", \"level\": \"primary\", \"actionType\": \"submit\"}], \"initApi\": {\"url\": \"/data-dict/detail\", \"data\": {\"id\": \"${id}\"}, \"method\": \"get\", \"adaptor\": \"\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"onEvent\": {\"submitSucc\": {\"actions\": [{\"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:77ac0e9b5953\"}]}}, \"labelAlign\": \"top\", \"resetAfterSubmit\": true}], \"size\": \"md\", \"type\": \"dialog\", \"title\": \"编辑数据\", \"actions\": [{\"id\": \"u:57dee6c6a570\", \"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"id\": \"u:2b815103fd93\", \"type\": \"button\", \"label\": \"提交\", \"level\": \"primary\", \"actionType\": \"submit\"}], \"draggable\": false, \"actionType\": \"dialog\", \"closeOnEsc\": true, \"showLoading\": true, \"showErrorMsg\": true, \"closeOnOutside\": true, \"showCloseButton\": true}, \"actionType\": \"dialog\"}]}}, \"behavior\": \"Edit\"}, {\"id\": \"u:a16a0b44b422\", \"type\": \"button\", \"label\": \"删除\", \"level\": \"link\", \"onEvent\": {\"click\": {\"actions\": [{\"api\": {\"url\": \"/data-dict/delete\", \"data\": {\"id\": \"${id}\"}, \"method\": \"get\", \"adaptor\": \"\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"options\": {}, \"outputVar\": \"responseResult\", \"actionType\": \"ajax\"}, {\"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:77ac0e9b5953\"}]}}, \"behavior\": \"Delete\", \"className\": \"m-r-xs text-danger\", \"confirmText\": \"确认要删除数据\"}, {\"id\": \"u:4d589237756e\", \"label\": \"编辑项\", \"level\": \"link\", \"onEvent\": {\"click\": {\"weight\": 0, \"actions\": [{\"data\": {\"dictName\": \"${dictName}\"}, \"dialog\": {\"id\": \"u:a710f825f1d2\", \"body\": [{\"id\": \"u:d4c104456101\", \"api\": {\"url\": \"/data-dict-item/querDictItemsByDictName\", \"data\": {\"dictName\": \"${dictName}\"}, \"method\": \"get\", \"adaptor\": \"\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"mode\": \"table2\", \"type\": \"crud2\", \"dsType\": \"api\", \"columns\": [{\"id\": \"u:94048c9bb64b\", \"name\": \"label\", \"type\": \"tpl\", \"title\": \"字典项标签\"}, {\"id\": \"u:702b13d42e5c\", \"name\": \"value\", \"type\": \"tpl\", \"title\": \"字典项值\"}, {\"id\": \"u:55414ec719ba\", \"type\": \"operation\", \"title\": \"操作\", \"buttons\": [{\"id\": \"u:890716b67406\", \"type\": \"button\", \"label\": \"编辑\", \"level\": \"link\", \"onEvent\": {\"click\": {\"actions\": [{\"dialog\": {\"id\": \"u:50726baa3991\", \"body\": [{\"id\": \"u:320137a7e575\", \"api\": {\"url\": \"/data-dict-item/edit\", \"method\": \"post\", \"adaptor\": \"\", \"dataType\": \"json\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"body\": [{\"id\": \"u:ed22c05150b0\", \"row\": 0, \"name\": \"label\", \"type\": \"input-text\", \"label\": \"字典项标签\", \"required\": true, \"placeholder\": \"字典项显示标签\"}, {\"id\": \"u:78fa33710b4c\", \"row\": 1, \"name\": \"value\", \"type\": \"input-text\", \"label\": \"字典项值\", \"required\": true, \"placeholder\": \"字典项值\"}, {\"id\": \"u:df373e73fb7f\", \"row\": 2, \"name\": \"id\", \"type\": \"input-text\", \"label\": \"id\", \"hidden\": true}], \"feat\": \"Edit\", \"mode\": \"flex\", \"type\": \"form\", \"title\": \"编辑数据\", \"dsType\": \"api\", \"actions\": [{\"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"type\": \"button\", \"label\": \"提交\", \"level\": \"primary\", \"actionType\": \"submit\"}], \"onEvent\": {\"submitSucc\": {\"actions\": [{\"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:d4c104456101\"}]}}, \"labelAlign\": \"top\", \"resetAfterSubmit\": true}], \"size\": \"md\", \"type\": \"dialog\", \"title\": \"编辑数据\", \"actions\": [{\"id\": \"u:7e89123508f7\", \"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"id\": \"u:379efd337ecb\", \"type\": \"button\", \"label\": \"提交\", \"level\": \"primary\", \"actionType\": \"submit\"}], \"draggable\": true, \"actionType\": \"dialog\", \"closeOnEsc\": true, \"showLoading\": true, \"showErrorMsg\": true, \"closeOnOutside\": true, \"showCloseButton\": true}, \"actionType\": \"dialog\"}]}}, \"behavior\": \"Edit\"}, {\"id\": \"u:7c1491332541\", \"type\": \"button\", \"label\": \"删除\", \"level\": \"link\", \"onEvent\": {\"click\": {\"actions\": [{\"api\": {\"url\": \"/data-dict-item/delete\", \"data\": {\"id\": \"${id}\"}, \"method\": \"get\", \"adaptor\": \"\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"options\": {}, \"outputVar\": \"responseResult\", \"actionType\": \"ajax\"}, {\"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:d4c104456101\"}]}}, \"behavior\": \"Delete\", \"className\": \"m-r-xs text-danger\", \"confirmText\": \"确认要删除数据\"}]}], \"loadType\": \"\", \"showHeader\": true, \"primaryField\": \"id\", \"syncLocation\": true, \"editorSetting\": {\"mock\": {\"enable\": true, \"maxDisplayRows\": 5}}, \"footerToolbar\": [{\"id\": \"u:2c38aeb8139d\", \"type\": \"flex\", \"items\": [{\"id\": \"u:1fa4d93e12ff\", \"body\": [], \"type\": \"container\", \"align\": \"left\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"flexBasis\": \"auto\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-start\"}, \"wrapperBody\": false}, {\"id\": \"u:c2b302f9b37c\", \"body\": [], \"type\": \"container\", \"align\": \"right\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-end\"}, \"wrapperBody\": false, \"isFixedHeight\": false}], \"style\": {\"position\": \"static\"}, \"justify\": \"flex-start\", \"direction\": \"row\", \"alignItems\": \"stretch\"}], \"headerToolbar\": [{\"id\": \"u:a9252053e6f0\", \"type\": \"flex\", \"items\": [{\"id\": \"u:172419964367\", \"body\": [{\"id\": \"u:6304b5722fc0\", \"type\": \"button\", \"label\": \"新增\", \"level\": \"primary\", \"onEvent\": {\"click\": {\"actions\": [{\"dialog\": {\"id\": \"u:43f3cf70fa70\", \"body\": [{\"id\": \"u:b17cccb19e55\", \"api\": {\"url\": \"/data-dict-item/add\", \"data\": {\"label\": \"${label}\", \"value\": \"${value}\", \"dictName\": \"${dictName}\"}, \"method\": \"post\", \"adaptor\": \"\", \"dataType\": \"json\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"body\": [{\"id\": \"u:650bdd046355\", \"row\": 0, \"name\": \"label\", \"type\": \"input-text\", \"label\": \"字典项标签\", \"required\": true, \"placeholder\": \"字典项显示标签\"}, {\"id\": \"u:be5665f2b6bb\", \"row\": 1, \"name\": \"value\", \"type\": \"input-text\", \"label\": \"字典项值\", \"required\": true, \"placeholder\": \"字典项值\"}, {\"id\": \"u:3cc7076a4053\", \"row\": 2, \"name\": \"dictName\", \"type\": \"input-text\", \"label\": \"\", \"hidden\": true}], \"feat\": \"Insert\", \"mode\": \"flex\", \"type\": \"form\", \"title\": \"表单\", \"dsType\": \"api\", \"actions\": [{\"type\": \"button\", \"label\": \"取消\", \"level\": \"default\", \"onEvent\": {\"click\": {\"actions\": [{\"actionType\": \"cancel\", \"componentId\": \"u:b17cccb19e55\"}]}}}, {\"type\": \"button\", \"label\": \"提交\", \"level\": \"primary\", \"onEvent\": {\"click\": {\"actions\": [{\"actionType\": \"submit\", \"componentId\": \"u:b17cccb19e55\"}]}}}], \"onEvent\": {\"submitSucc\": {\"actions\": [{\"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:d4c104456101\"}]}}, \"labelAlign\": \"top\", \"resetAfterSubmit\": true}], \"size\": \"md\", \"type\": \"dialog\", \"title\": \"新增数据\", \"actions\": [{\"id\": \"u:29d617368bae\", \"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"id\": \"u:d34d76dd6644\", \"type\": \"button\", \"label\": \"提交\", \"level\": \"primary\", \"actionType\": \"submit\"}], \"draggable\": true, \"actionType\": \"dialog\", \"closeOnEsc\": true, \"hideActions\": false, \"showLoading\": true, \"showErrorMsg\": true, \"dataMapSwitch\": false, \"closeOnOutside\": true, \"showCloseButton\": true, \"withDefaultData\": false}, \"actionType\": \"dialog\"}]}}, \"behavior\": \"Insert\", \"className\": \"m-r-xs\"}], \"type\": \"container\", \"align\": \"left\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"flexBasis\": \"auto\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-start\"}, \"behavior\": [\"Insert\", \"BulkEdit\", \"BulkDelete\"], \"wrapperBody\": false}, {\"id\": \"u:407e5c7c2e35\", \"body\": [], \"type\": \"container\", \"align\": \"right\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"flexBasis\": \"auto\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-end\"}, \"behavior\": [\"FuzzyQuery\"], \"wrapperBody\": false}], \"style\": {\"position\": \"static\"}, \"justify\": \"flex-start\", \"direction\": \"row\", \"alignItems\": \"stretch\"}]}], \"size\": \"lg\", \"type\": \"dialog\", \"title\": \"字典子项\", \"actions\": [{\"id\": \"u:41b9f80f03d8\", \"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"id\": \"u:d86dea1118ab\", \"type\": \"button\", \"label\": \"确定\", \"primary\": true, \"actionType\": \"confirm\"}], \"draggable\": true, \"actionType\": \"dialog\", \"closeOnEsc\": true, \"showLoading\": true, \"showErrorMsg\": true, \"closeOnOutside\": true, \"showCloseButton\": true}, \"actionType\": \"dialog\", \"ignoreError\": false}]}}, \"wrapperCustomStyle\": {\"root\": {\"color\": \"orange !important\"}}}]}], \"loadType\": \"pagination\", \"primaryField\": \"id\", \"syncLocation\": false, \"editorSetting\": {\"mock\": {\"enable\": true, \"maxDisplayRows\": 5}}, \"footerToolbar\": [{\"id\": \"u:77cbb5c1055f\", \"type\": \"flex\", \"items\": [{\"id\": \"u:b4d9b7a0c821\", \"body\": [], \"type\": \"container\", \"align\": \"left\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"flexBasis\": \"auto\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-start\"}, \"wrapperBody\": false}, {\"id\": \"u:cfa613db8540\", \"body\": [{\"id\": \"u:bc64ff2f35d6\", \"type\": \"pagination\", \"layout\": [\"total\", \"perPage\", \"pager\"], \"behavior\": \"Pagination\", \"perPageAvailable\": [10, 20, 50, 100]}], \"type\": \"container\", \"align\": \"right\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"flexBasis\": \"auto\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-end\"}, \"wrapperBody\": false}], \"style\": {\"position\": \"static\"}, \"justify\": \"flex-start\", \"direction\": \"row\", \"alignItems\": \"stretch\"}], \"headerToolbar\": [{\"id\": \"u:a9cf0085e636\", \"type\": \"flex\", \"items\": [{\"id\": \"u:06bbc8fb1e23\", \"body\": [{\"id\": \"u:4e1915b02a79\", \"type\": \"button\", \"label\": \"新增\", \"level\": \"primary\", \"onEvent\": {\"click\": {\"actions\": [{\"dialog\": {\"id\": \"u:75919ace4ec8\", \"body\": [{\"id\": \"u:7b922379aa6a\", \"api\": {\"url\": \"/data-dict/add\", \"data\": {\"dictName\": \"${dictName}\", \"dictLabel\": \"${dictLabel}\"}, \"method\": \"post\", \"adaptor\": \"\", \"dataType\": \"json\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"body\": [{\"id\": \"u:570c1bd9d891\", \"row\": 0, \"name\": \"dictLabel\", \"type\": \"input-text\", \"label\": \"字典标签\", \"required\": true, \"placeholder\": \"字典中文名\"}, {\"id\": \"u:0229e2b29e03\", \"row\": 1, \"name\": \"dictName\", \"type\": \"input-text\", \"label\": \"字典名称\", \"required\": true, \"placeholder\": \"字典英文名\"}], \"feat\": \"Insert\", \"mode\": \"flex\", \"type\": \"form\", \"title\": \"新增数据\", \"dsType\": \"api\", \"actions\": [{\"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"type\": \"button\", \"label\": \"提交\", \"level\": \"primary\", \"actionType\": \"submit\"}], \"onEvent\": {\"submitSucc\": {\"actions\": [{\"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:77ac0e9b5953\"}]}}, \"labelAlign\": \"top\", \"resetAfterSubmit\": true}], \"size\": \"md\", \"type\": \"dialog\", \"title\": \"新增数据\", \"actions\": [{\"id\": \"u:94c0ce3c7f1f\", \"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"id\": \"u:ed597c91808b\", \"type\": \"button\", \"label\": \"提交\", \"level\": \"primary\", \"actionType\": \"submit\"}], \"draggable\": true, \"actionType\": \"dialog\", \"closeOnEsc\": true, \"showLoading\": true, \"showErrorMsg\": true, \"closeOnOutside\": true, \"showCloseButton\": true}, \"actionType\": \"dialog\"}]}}, \"behavior\": \"Insert\", \"className\": \"m-r-xs\"}], \"type\": \"container\", \"align\": \"left\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-start\"}, \"behavior\": [\"Insert\", \"BulkEdit\", \"BulkDelete\"], \"wrapperBody\": false, \"isFixedHeight\": false}, {\"id\": \"u:7606a9c76094\", \"body\": [], \"type\": \"container\", \"align\": \"right\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"flexBasis\": \"auto\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-end\"}, \"behavior\": [\"FuzzyQuery\"], \"wrapperBody\": false}], \"style\": {\"position\": \"static\"}, \"justify\": \"flex-start\", \"direction\": \"row\", \"alignItems\": \"stretch\"}]}], \"regions\": [\"body\"], \"definitions\": {}, \"pullRefresh\": {\"disabled\": true}, \"asideResizor\": false}', '2', '数据字典', 'data-dict', 'DataBoard', '2025-08-19 16:16:33', '2025-08-28 20:03:12', '0', NULL, NULL, NULL, 0, '{\"webShowFlag\": 1}');
INSERT INTO `system_application_web` (`id`, `parent_id`, `app_id`, `data`, `type`, `label`, `code`, `icon`, `create_time`, `update_time`, `del_flag`, `create_by`, `update_by`, `remarks`, `sort`, `extra`) VALUES ('b0216da124a449138c48aed53cc4ed6a', '969e416f9e03421a8d78b381fd3f7247', '000000000000000000000000000000', '{\"id\": \"u:329cfd874a23\", \"body\": [{\"id\": \"u:9144d4b7f9c9\", \"api\": {\"url\": \"/business-user/list\", \"method\": \"get\"}, \"mode\": \"table2\", \"type\": \"crud2\", \"dsType\": \"api\", \"filter\": {\"id\": \"u:e57da6b20ece\", \"body\": [{\"id\": \"u:248603c2b289\", \"name\": \"name\", \"size\": \"full\", \"type\": \"input-text\", \"label\": \"姓名\", \"behavior\": \"SimpleQuery\", \"required\": false}, {\"id\": \"u:e458bedde5f0\", \"name\": \"account\", \"size\": \"full\", \"type\": \"input-text\", \"label\": \"账号\", \"behavior\": \"SimpleQuery\", \"required\": false}], \"feat\": \"Insert\", \"mode\": \"inline\", \"type\": \"form\", \"title\": \"条件查询\", \"actions\": [{\"id\": \"u:80cf2298a459\", \"type\": \"reset\", \"label\": \"重置\"}, {\"id\": \"u:9d7f4b09f123\", \"type\": \"submit\", \"label\": \"查询\", \"level\": \"primary\"}], \"behavior\": [\"SimpleQuery\"], \"columnCount\": 3, \"clearValueOnHidden\": true}, \"columns\": [{\"id\": \"u:d268ad8288fb\", \"name\": \"name\", \"type\": \"tpl\", \"title\": \"姓名\", \"placeholder\": \"-\"}, {\"id\": \"u:8adc36652d06\", \"name\": \"account\", \"type\": \"tpl\", \"title\": \"账号\", \"placeholder\": \"-\"}, {\"id\": \"u:d784e36e5d76\", \"name\": \"password\", \"type\": \"tpl\", \"title\": \"密码\"}, {\"id\": \"u:144b7a3fce12\", \"name\": \"mobile\", \"type\": \"tpl\", \"title\": \"手机号\", \"placeholder\": \"-\"}, {\"id\": \"u:9327491d64dd\", \"name\": \"age\", \"type\": \"tpl\", \"title\": \"年龄\", \"placeholder\": \"-\"}, {\"id\": \"u:715965b83f48\", \"body\": [{\"id\": \"u:bb50f88c7ed1\", \"type\": \"tag\", \"color\": \"processing\", \"label\": \"${IF(sex ==\'0\',\'男\',\'女\')}\", \"closable\": false, \"displayMode\": \"normal\"}], \"name\": \"sex\", \"type\": \"container\", \"style\": {\"display\": \"block\", \"position\": \"static\"}, \"title\": \"性别\", \"placeholder\": \"-\", \"wrapperBody\": false, \"isFixedWidth\": false, \"isFixedHeight\": false}, {\"id\": \"u:a8b4abe01cf0\", \"type\": \"operation\", \"title\": \"操作\", \"buttons\": [{\"id\": \"u:ade8d85dafd3\", \"type\": \"button\", \"label\": \"查看\", \"level\": \"link\", \"onEvent\": {\"click\": {\"actions\": [{\"dialog\": {\"body\": {\"id\": \"u:b464aae2878f\", \"body\": [{\"row\": 0, \"name\": \"account\", \"type\": \"input-text\", \"label\": \"账号\"}, {\"row\": 1, \"name\": \"password\", \"type\": \"input-text\", \"label\": \"密码\"}, {\"row\": 2, \"name\": \"mobile\", \"type\": \"input-text\", \"label\": \"手机号\"}, {\"row\": 3, \"name\": \"age\", \"type\": \"input-number\", \"label\": \"年龄\"}, {\"row\": 4, \"name\": \"sex\", \"type\": \"radios\", \"label\": \"性别\"}], \"feat\": \"View\", \"mode\": \"flex\", \"type\": \"form\", \"title\": \"查看数据\", \"dsType\": \"api\", \"static\": true, \"actions\": [{\"type\": \"button\", \"label\": \"关闭\", \"actionType\": \"cancel\"}], \"onEvent\": {\"submitSucc\": {\"actions\": [{\"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:9144d4b7f9c9\"}]}}, \"labelAlign\": \"top\"}, \"size\": \"md\", \"type\": \"dialog\", \"title\": \"查看数据\", \"actions\": [{\"type\": \"button\", \"label\": \"关闭\", \"actionType\": \"cancel\"}], \"actionType\": \"dialog\"}, \"actionType\": \"dialog\"}]}}, \"behavior\": \"View\"}, {\"id\": \"u:fd10145cdfd4\", \"type\": \"button\", \"label\": \"编辑\", \"level\": \"link\", \"onEvent\": {\"click\": {\"actions\": [{\"dialog\": {\"id\": \"u:91f26efbe965\", \"body\": [{\"id\": \"u:82c4083c5bc2\", \"api\": {\"url\": \"/business-user/edit\", \"data\": {\"&\": \"$$\", \"id\": \"${id}\"}, \"method\": \"post\", \"adaptor\": \"\", \"dataType\": \"json\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"body\": [{\"id\": \"u:ff93fd3d176f\", \"row\": 0, \"name\": \"name\", \"type\": \"input-text\", \"label\": \"姓名\", \"colSize\": \"1/2\"}, {\"id\": \"u:f8cc33170f71\", \"row\": 0, \"name\": \"sex\", \"type\": \"radios\", \"label\": \"性别\", \"colSize\": \"1/2\", \"options\": [{\"label\": \"男\", \"value\": \"0\"}, {\"label\": \"女\", \"value\": \"1\"}]}, {\"id\": \"u:eeb5c00f4da9\", \"row\": 1, \"name\": \"account\", \"type\": \"input-text\", \"label\": \"账号\", \"colSize\": \"1/2\"}, {\"id\": \"u:d578504032f2\", \"row\": 1, \"name\": \"password\", \"type\": \"input-text\", \"label\": \"密码\", \"colSize\": \"1/2\"}, {\"id\": \"u:182b7eef30cd\", \"row\": 2, \"name\": \"mobile\", \"type\": \"input-text\", \"label\": \"手机号\", \"colSize\": \"1/2\"}, {\"id\": \"u:ed2d78f12271\", \"row\": 2, \"name\": \"age\", \"step\": 1, \"type\": \"input-number\", \"label\": \"年龄\", \"colSize\": \"1/2\", \"keyboard\": true}], \"feat\": \"Edit\", \"mode\": \"flex\", \"type\": \"form\", \"title\": \"编辑数据\", \"dsType\": \"api\", \"actions\": [{\"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"type\": \"button\", \"label\": \"提交\", \"level\": \"primary\", \"actionType\": \"submit\"}], \"onEvent\": {\"submitSucc\": {\"actions\": [{\"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:9144d4b7f9c9\"}]}}, \"labelAlign\": \"top\", \"resetAfterSubmit\": true}], \"size\": \"md\", \"type\": \"dialog\", \"title\": \"编辑数据\", \"actions\": [{\"id\": \"u:33ac798062bf\", \"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"id\": \"u:3866abaf7de2\", \"type\": \"button\", \"label\": \"提交\", \"level\": \"primary\", \"actionType\": \"submit\"}], \"draggable\": false, \"actionType\": \"dialog\", \"closeOnEsc\": false, \"showLoading\": true, \"showErrorMsg\": true, \"closeOnOutside\": false, \"showCloseButton\": true}, \"actionType\": \"dialog\"}]}}, \"behavior\": \"Edit\"}, {\"id\": \"u:71a10d6b31cd\", \"label\": \"角色\", \"level\": \"link\", \"onEvent\": {\"click\": {\"weight\": 0, \"actions\": [{\"dialog\": {\"$ref\": \"modal-ref-1\"}, \"actionType\": \"dialog\", \"ignoreError\": false}]}}}, {\"id\": \"u:6d79b5b1db23\", \"type\": \"button\", \"label\": \"删除\", \"level\": \"link\", \"onEvent\": {\"click\": {\"actions\": [{\"api\": {\"url\": \"/business-user/delete\", \"data\": {\"id\": \"${id}\"}, \"method\": \"post\", \"adaptor\": \"\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"options\": {}, \"outputVar\": \"responseResult\", \"actionType\": \"ajax\"}, {\"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:9144d4b7f9c9\"}]}}, \"behavior\": \"Delete\", \"className\": \"m-r-xs text-danger\", \"confirmText\": \"确认要删除数据\"}]}], \"loadType\": \"pagination\", \"showHeader\": true, \"loadDataOnce\": false, \"primaryField\": \"id\", \"syncLocation\": false, \"editorSetting\": {\"mock\": {\"enable\": true, \"maxDisplayRows\": 5}}, \"footerToolbar\": [{\"id\": \"u:527d5ed50064\", \"type\": \"flex\", \"items\": [{\"id\": \"u:618f06d4568c\", \"body\": [], \"type\": \"container\", \"align\": \"left\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"flexBasis\": \"auto\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-start\"}, \"wrapperBody\": false}, {\"id\": \"u:48a8a3896a7c\", \"body\": [{\"id\": \"u:1387f32f2efb\", \"type\": \"pagination\", \"layout\": [\"total\", \"perPage\", \"pager\"], \"behavior\": \"Pagination\", \"perPageAvailable\": [10, 20, 50, 100]}], \"type\": \"container\", \"align\": \"right\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"flexBasis\": \"auto\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-end\"}, \"wrapperBody\": false}], \"style\": {\"position\": \"static\"}, \"justify\": \"flex-start\", \"direction\": \"row\", \"alignItems\": \"stretch\"}], \"headerToolbar\": [{\"id\": \"u:12a78998f136\", \"type\": \"flex\", \"items\": [{\"id\": \"u:6eaa48b45003\", \"body\": [{\"id\": \"u:47986b357e95\", \"type\": \"button\", \"label\": \"新增\", \"level\": \"primary\", \"onEvent\": {\"click\": {\"actions\": [{\"dialog\": {\"id\": \"u:2b284be8a7db\", \"body\": [{\"id\": \"u:36b7087bb241\", \"body\": [{\"id\": \"u:b830fad0cdc7\", \"row\": 0, \"name\": \"name\", \"type\": \"input-text\", \"label\": \"姓名\", \"colSize\": \"1/2\", \"onEvent\": {\"change\": {\"weight\": 0, \"actions\": []}}, \"required\": true, \"maxLength\": 32, \"validations\": {\"maxLength\": 32}, \"validateOnChange\": false}, {\"id\": \"u:d4a2a674592d\", \"row\": 0, \"name\": \"sex\", \"type\": \"radios\", \"label\": \"性别\", \"value\": \"1\", \"colSize\": \"1/2\", \"options\": [{\"label\": \"男\", \"value\": \"0\"}, {\"label\": \"女\", \"value\": \"1\"}], \"autoFill\": {}, \"required\": true, \"validateOnChange\": false}, {\"id\": \"u:97b3fc87863c\", \"row\": 1, \"name\": \"account\", \"type\": \"input-text\", \"label\": \"账号\", \"colSize\": \"1/2\", \"onEvent\": {\"change\": {\"weight\": 0, \"actions\": []}}, \"required\": true, \"maxLength\": 32, \"validations\": {\"maxLength\": 32, \"minLength\": 6}, \"validateOnChange\": false}, {\"id\": \"u:415d7d97ddea\", \"row\": 1, \"name\": \"password\", \"type\": \"input-password\", \"label\": \"密码\", \"colSize\": \"1/2\", \"required\": true, \"maxLength\": 32, \"showCounter\": false, \"validations\": {\"maxLength\": 32, \"minLength\": 6}, \"validateOnChange\": false, \"validationErrors\": {}}, {\"id\": \"u:ae083f274958\", \"row\": 2, \"name\": \"mobile\", \"type\": \"input-text\", \"label\": \"手机号\", \"colSize\": \"1/2\", \"maxLength\": 32, \"validations\": {\"maxLength\": 32}, \"validateOnChange\": false}, {\"id\": \"u:42f0292f6e1a\", \"row\": 2, \"name\": \"age\", \"step\": 2, \"type\": \"input-number\", \"label\": \"年龄\", \"colSize\": \"1/2\", \"keyboard\": true, \"required\": true, \"precision\": \"\", \"validateOnChange\": false}], \"feat\": \"Insert\", \"mode\": \"flex\", \"type\": \"form\", \"title\": \"新增数据\", \"dsType\": \"api\", \"actions\": [{\"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"type\": \"button\", \"label\": \"提交\", \"level\": \"primary\", \"actionType\": \"submit\"}], \"onEvent\": {\"submitSucc\": {\"actions\": [{\"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:9144d4b7f9c9\"}]}}, \"labelAlign\": \"top\", \"resetAfterSubmit\": true}], \"size\": \"md\", \"type\": \"dialog\", \"title\": \"新增数据\", \"actions\": [{\"id\": \"u:73df24e016d5\", \"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"id\": \"u:baac0f795948\", \"type\": \"button\", \"label\": \"提交\", \"level\": \"primary\", \"onEvent\": {\"click\": {\"weight\": 0, \"actions\": [{\"args\": {}, \"outputVar\": \"result\", \"actionType\": \"validate\", \"componentId\": \"u:36b7087bb241\", \"ignoreError\": false, \"stopPropagation\": \"${IF(event.data.result.error==\'依赖的部分字段没有通过验证\',true,false)}\"}, {\"api\": {\"url\": \"/business-user/add\", \"data\": {\"&\": \"${event.data.result.payload}\"}, \"method\": \"post\", \"adaptor\": \"\", \"dataType\": \"json\", \"messages\": {}, \"replaceData\": true, \"requestAdaptor\": \"\"}, \"options\": {\"silent\": false}, \"outputVar\": \"responseResult\", \"actionType\": \"ajax\"}]}}, \"actionType\": \"submit\"}], \"draggable\": false, \"actionType\": \"dialog\", \"closeOnEsc\": false, \"showLoading\": true, \"showErrorMsg\": true, \"closeOnOutside\": false, \"showCloseButton\": true}, \"actionType\": \"dialog\"}]}}, \"behavior\": \"Insert\", \"className\": \"m-r-xs\"}], \"type\": \"container\", \"align\": \"left\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-start\"}, \"behavior\": [\"Insert\", \"BulkEdit\", \"BulkDelete\"], \"wrapperBody\": false, \"isFixedHeight\": false}, {\"id\": \"u:04b826cc542a\", \"body\": [], \"type\": \"container\", \"align\": \"right\", \"style\": {\"flex\": \"1 1 auto\", \"display\": \"flex\", \"flexGrow\": 1, \"flexWrap\": \"nowrap\", \"position\": \"static\", \"flexBasis\": \"auto\", \"alignItems\": \"stretch\", \"flexDirection\": \"row\", \"justifyContent\": \"flex-end\"}, \"behavior\": [\"FuzzyQuery\"], \"wrapperBody\": false}], \"style\": {\"position\": \"static\"}, \"justify\": \"flex-start\", \"direction\": \"row\", \"alignItems\": \"stretch\"}]}], \"definitions\": {\"modal-ref-1\": {\"id\": \"u:509549b4538e\", \"body\": [{\"id\": \"u:9972cf540184\", \"name\": \"roleList\", \"type\": \"transfer\", \"label\": \"\", \"source\": \"/business-role/list\", \"required\": true, \"sortable\": true, \"valueTpl\": \"\", \"labelField\": \"name\", \"searchable\": true, \"selectMode\": \"list\", \"valueField\": \"id\", \"selectTitle\": \"\", \"resultSearchable\": true, \"resultListModeFollowSelect\": false}], \"type\": \"dialog\", \"$$ref\": \"modal-ref-1\", \"title\": \"角色\", \"actions\": [{\"id\": \"u:e8230e20108d\", \"type\": \"button\", \"label\": \"取消\", \"actionType\": \"cancel\"}, {\"id\": \"u:27b2708310ff\", \"type\": \"button\", \"label\": \"确定\", \"onEvent\": {\"click\": {\"weight\": 0, \"actions\": [{\"api\": {\"url\": \"/business-user-role/add\", \"data\": {\"userId\": \"${id}\", \"roleList\": \"${roleList}\"}, \"method\": \"post\", \"adaptor\": \"\", \"dataType\": \"json\", \"messages\": {}, \"requestAdaptor\": \"\"}, \"options\": {}, \"outputVar\": \"responseResult\", \"actionType\": \"ajax\", \"ignoreError\": false}, {\"args\": {}, \"groupType\": \"component\", \"actionType\": \"search\", \"componentId\": \"u:9144d4b7f9c9\"}], \"debounce\": {\"wait\": 100}}}, \"primary\": true, \"actionType\": \"confirm\"}], \"onEvent\": {\"confirm\": {\"weight\": 0, \"actions\": []}}, \"draggable\": true, \"closeOnEsc\": true, \"hideActions\": false, \"inputParams\": {\"type\": \"object\", \"required\": [], \"properties\": {}}, \"showLoading\": true, \"showErrorMsg\": true, \"dataMapSwitch\": false, \"editorSetting\": {\"displayName\": \"角色替换弹窗\"}, \"closeOnOutside\": true, \"showCloseButton\": true, \"withDefaultData\": false}}, \"pullRefresh\": {\"disabled\": true}, \"asideResizor\": false}', '2', '用户管理', 'user-management', 'User', '2025-08-12 19:09:05', '2025-08-28 20:03:12', '0', NULL, NULL, NULL, 1, '{\"webShowFlag\": 1}');
COMMIT;

-- ----------------------------
-- Table structure for system_user
-- ----------------------------
DROP TABLE IF EXISTS `system_user`;
CREATE TABLE `system_user` (
                               `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
                               `account` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                               `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                               `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                               `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                               `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                               `create_time` datetime DEFAULT NULL,
                               `update_time` datetime DEFAULT NULL,
                               `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0',
                               `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                               PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of system_user
-- ----------------------------
BEGIN;
INSERT INTO `system_user` (`id`, `account`, `password`, `username`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `remarks`) VALUES ('1', 'admin', '666666', '系统管理员', NULL, NULL, NULL, NULL, '0', NULL);
COMMIT;

-- ----------------------------
-- Table structure for system_user_application
-- ----------------------------
DROP TABLE IF EXISTS `system_user_application`;
CREATE TABLE `system_user_application` (
                                           `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
                                           `user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户id',
                                           `app_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '应用id',
                                           PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of system_user_application
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for test
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
                        `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键id',
                        `create_by` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
                        `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                        `update_by` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新人',
                        `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                        `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
                        `del_flag` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '删除标识（0：未删除 1：已删除）',
                        `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                        `start_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                        PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of test
-- ----------------------------
BEGIN;
INSERT INTO `test` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `name`, `start_time`) VALUES ('1fc4ee79d6b14cc28e2709bb9b5f8392', NULL, '2025-08-30 00:29:34', NULL, '2025-08-30 00:30:42', NULL, '1', '测试', '2025-08-30 00:30:42');
INSERT INTO `test` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `name`, `start_time`) VALUES ('41db649f8e9747deb445ae51e7b1d9c2', NULL, '2025-08-30 00:25:21', NULL, '2025-08-30 00:26:35', NULL, '0', '测试-update', '2025-08-29 00:00:00');
INSERT INTO `test` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`, `del_flag`, `name`, `start_time`) VALUES ('a08246aa055e4c77b27b87fe42cc963d', NULL, '2025-08-30 00:29:36', NULL, '2025-08-30 00:29:36', NULL, '0', '测试', '2025-08-29 00:00:00');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
